Posts made by Visvanath Ratnaweera

Picture of Particularly helpful Moodlers Picture of Translators
Hi Emma, hi Rick

Thanks for reporting your observations! So this is the normal behaviour of Moodle. Importing and duplicating of complete quizzes are slow. The teachers who are experiencing this issue use MC tests heavily. Apart from the common quiz "originals" mentioned earlier, they have created many question categories under their dept. course category, totaling more then 1,500 questions.

Now on how to go ahead?
a) Does this process have potential for optimization? In that case we should find the tracker issues, if there are any, or add a tracker issue.

b) Could significant improvement achieved by system optimization, like DB optimizations, caches, etc?

c) Can we suggest alternative work-flow for them?

I am not expecting answers to all of them here, just thinking aloud.
Average of ratings: Useful (1)

Moodle in English -> Quiz -> Importing quizzes is slow

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
Hi

A team of teachers share complete quizzes by maintaining the "original" quiz in one course (where all have the Teacher role) and importing them to their personal courses. They have a case where such an import takes 25 minutes!

Here are the details:
- The quiz has 50 questions, all Multiple-choice. All text heavy, with some containing images in the questions, some in the answers. Sizes around 50 to 400 kB. No audio, no video.

- The server is a dedicated Intel Xeon 2.4 GHz, quad core, 16 GB RAM, 4 TB SATA with (software) RAID 1.

- Moodle release 3.5 on LAMP (Debian 9, Apache, MariaDB), PHP 7.0, Opcache enabled 256 MB (only half being used)

- Performs beautifully in day-to-day operations which includes heave use of quiz, synchronously in classes of 15 to 25 students, sometimes three classes in parallel. No complaints about performance.

My initial guess is that the either the import procedure is very heavy on database - something similar to https://tracker.moodle.org/browse/MDL-29439 (which is very old and possibly not related). But sporadically there were enquiries like "Slow backup and restore of small quizes where there's a lot of question in course" https://moodle.org/mod/forum/discuss.php?d=379783.

Before starting on the general performance of the server or throwing more resources, I want to check with the quiz specialists whether this is to be expected.
Average of ratings: -