Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-73804

make_categories_list is extremely slow when performing course management

    XMLWordPrintable

Details

    Description

      Using the /course/management.php page to do any course actions will lead to the 'coursecat' cache getting repeatedly purged and rebuilt over and over.

      This is extremely similar to MDL-67428 but a different instance where generating all the category info at the system context would be extremely beneficial from a performance perspective, as the active filters would only need to load for 1 context, not n coursecats. This can take an extremely long time when filters are being applied to all data, as the filter chain needs to be looked up from the database for each coursecat context, and it gets immediately purged and needs to be rebuilt after an action.

      This is therefore reliant on MDL-67428, and leverages the same filter setting.

      Attachments

        Issue Links

          Activity

            People

              peterburnett Peter Burnett
              peterburnett Peter Burnett
              Brendan Heywood Brendan Heywood
              Victor Déniz Falcón Victor Déniz Falcón
              CiBoT CiBoT
              Votes:
              2 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                16/Jan/23

                Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 5 hours, 2 minutes
                  5h 2m