Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 3.3, 3.4
-
Testing Instructions:
- Download the file create_users_courses_groups_assignments.php
and put it in Moodle's root directory - Run the above file (php create_users_courses_groups_assignments). This will create 500 courses each of which contains an assignment and some groups, create some students and courses in the course.
- BEFORE APPLYING THE PATCH, log in using one of the new students the above script created. For example use (username: s1, password: test). This user should be enrolled in many courses.
- Take a note of the performance information. in particular, number of DB reads and writes.
- APPLY THE PATCH and repeats steps 3 and 4.
- The number of DB reads should be dropped by nearly 30%
Download the file create_users_courses_groups_assignments.php and put it in Moodle's root directory Run the above file (php create_users_courses_groups_assignments). This will create 500 courses each of which contains an assignment and some groups, create some students and courses in the course. BEFORE APPLYING THE PATCH, log in using one of the new students the above script created. For example use (username: s1, password: test). This user should be enrolled in many courses. Take a note of the performance information. in particular, number of DB reads and writes. APPLY THE PATCH and repeats steps 3 and 4. The number of DB reads should be dropped by nearly 30% - Download the file create_users_courses_groups_assignments.php
-
Affected Branches:MOODLE_33_STABLE, MOODLE_34_STABLE
-
Fixed Branches:MOODLE_33_STABLE, MOODLE_34_STABLE
-
Pull from Repository:
-
Pull 3.3 Branch:
MDL-60188-33 -
Pull 3.3 Diff URL:
-
Pull 3.4 Branch:
MDL-60188-34 -
Pull 3.4 Diff URL:
-
Pull Master Branch:
MDL-60188-master -
Pull Master Diff URL:
Description
The calendar calls the function groups_get_user_groups quite often, which executes one database query each time.
When a user is enrolled in 130 courses, I observed that the dashboard generates about 1200 queries, 920 of these thanks to the calendar calling groups_get_user_groups.