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

make_categories_list is extremely slow when performing course management

XMLWordPrintable

      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.

        1. Category after.png
          59 kB
          Peter Burnett
        2. Category before.png
          165 kB
          Peter Burnett

            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

              Created:
              Updated:
              Resolved:

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

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.