-
Improvement
-
Resolution: Won't Do
-
Minor
-
None
-
4.0.2
-
None
-
MOODLE_400_STABLE
This is a follow-up to MDL-74762.
At the moment, the only link between the cached quiz statistics is munged up in the hashcode column. This works, but is very difficult to query (for example when the quiz_statistics\task\recalculate wants to find which sets of stats which need to be updated because there are new attempts.
So, we should probably add a quizid column to the quiz_statistics table, and update the task to use it.
It will also help to clean up stats of quizzes which are deleted
- Discovered while testing
-
MDL-74762 Statistics in the Moodle 4.0 question bank use many DB queries causing performance problems
-
- Closed
-
- has a non-specific relationship to
-
-
- Closed
-
- will be (partly) resolved by
-
-
- Closed
-