-
Bug
-
Resolution: Unresolved
-
Minor
-
None
-
5.0.2, 4.5.6
We've seen a handful of queue_quiz_open_notification_tasks_for_users adhoc tasks taking multiple hours on a site that has a large amount of users per course and a lot of groups and overrides. One of the examples had over 50 million DB reads, which is excessive for such a simple a task.
The bottle neck appears to be within groups_is_member() inside update_user_with_date_overrides() - the DB query is being called for every override for every user, which really adds up when a course has thousands of users and overrides.
This should really be loaded into memory instead if possible.