Quiz tracking scheduled tasks cause the dashboard in progress and student search reports to stop working.

[vladkidanov]

Issue

One of our clients has over 10 million records inside local_assessfreq_trend produced by quiz_tracking scheduled task. The get_quiz_tracking method inside the classes/quiz.php tries to get those records and eventually stops. Some quizzes have almost 200 thousand records inside that table. I tried to use raise_memory_limit(MEMORY_HUGE), but it didn't help much.

Proposal

Is it possible to add a cleanup local_assessfreq_trend table feature or optimize the plugin so it would be capable of operating big data objects more efficiently?

Errors