-
Improvement
-
Resolution: Fixed
-
Minor
-
2.1, 2.2
-
MySQL
-
MOODLE_21_STABLE, MOODLE_22_STABLE
-
MOODLE_21_STABLE, MOODLE_22_STABLE
-
w04_
MDL-30509_m22_slowcohort -
-
A site that has thousands of users enrolled by cron synch has flagged a significant delay in the cron with the query to "remove unwanted roles" in enrol/cohort/locallib.php function enrol_cohort_sync()
It does admit to "take a long time" during upgrade, but it does on every cron execution, and I think it can be a lot faster (less than 1/10th the time according to my testing in MySQL) by rewriting the outer join as a WHERE NOT EXISTS clause.
- has a non-specific relationship to
-
MDL-31374 backport meta course sync plugin fixes and improvements from master to 2.2
-
- Closed
-
-
MDL-29684 meta course sync plugin fixes and improvements
-
- Closed
-
-
MDL-30944 fix bugs and improve enrol_cohort
-
- Closed
-
- is blocked by
-
MDL-30789 add update_status() method to enrol plugins
-
- Closed
-