-
Improvement
-
Resolution: Duplicate
-
Minor
-
None
-
2.3.1
-
None
-
MOODLE_23_STABLE
get_users_by_capability() without any limits is used throughout the quiz reporting, in courses with many enrolments this results in the max_memory_limit being hit and very large queries being created because of the use on IN() statements filled with enrolled users id's.
Replacing get_users_by_capability() with get_enrolled_sql() may be a better approach. In my own testing it performs much better, but there may be some corner cases I'm not aware of that mean that get_enrolled_sql may be appropriate.
- duplicates
-
MDL-27072 Quiz reports should use enroled users code, not get_users_by_capability
- Closed