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

Regression caused by MDL-76174 - "fix" incredibly slow on large site

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • 4.1.4, 4.2, 4.2.1
    • Blocks, Dashboard (My home)
    • None
    • MOODLE_401_STABLE, MOODLE_402_STABLE

      When testing the patch from MDL-76174, we found that it would cause my/courses.php to go from slow (the original problem) to unusable. The page would load forever (effectively).

      The full story is in the comments for MDL-76174 but it turns out that the SQL query performs badly when there are large numbers of role assignment at course category level. Our site has over 4,000.

       

            bonczek Lars Bonczek
            howardsmiller Howard Miller
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

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