Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 2.5.1
-
Fix Version/s: 2.5.2
-
Component/s: Course
-
Labels:
-
Testing Instructions:
-
Affected Branches:MOODLE_25_STABLE
-
Fixed Branches:MOODLE_25_STABLE
-
Pull from Repository:
-
Pull Master Branch:wip-
MDL-41114-master -
Pull Master Diff URL:
Description
During some performance testing of courses/coursecat listings I found several bugs that significantly decrease performance in case of large amount of course categories.
- function coursecat::make_categories_list() does not use retrieved contexts and has to query them again.
- /course/manage.php uses field coursecat::$coursecount that was not fetched when retrieving the course category children.
- make_categories_options() unnecessary queries the course categories table again.
Both fixes are one-line so I submit them in one issue.