Hi all,
Our Moodle (3.1.3 on PHP 5.6) is facing a slow loading situation.
One of courses contains few thousands quizzes, and when users get into this course or any quiz under this course, the loading speed is much longer.
I put a bit of codes in the the moodle_database class for the sql counter, and found this course and its related page would run 5000+ queries (looping for getting context). For the quiz part, the sql almost half came navigation, another half came from the filter? (Not quite sure by now)
However, if I go to another course with much less quiz, it loads fast.
It seems like Moodle will loop all the course_modules to apply each active filters and find the active nodes for the nav.
Is there any way make the loading speed much faster? We do not much using the filters from the 3rd party plugin, we will develop our own question type for quiz.
Many thanks