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

Gradebook performance improvements for Moodle 3.1

    XMLWordPrintable

    Details

    • Affected Branches:
      MOODLE_28_STABLE
    • Epic Name:
      Gradebook performance improvements

      Description

      In large courses (500+ students) with a decent amount of gradebook entries, a gradebook regrade caused by adding/moving/modifying a grade item can take a really long time, often several minutes.

      To test this, extend the testing instructions from https://tracker.moodle.org/browse/MDL-51498 by adding grades to more assignments and monitoring the regrade time after triggering a gradebook regrade. Even in https://tracker.moodle.org/browse/MDL-51498 a 20+ second query time to regrade an almost empty gradebook with 300 grades is unacceptable.

      From what I can tell, regrading is very liberal in choosing which grade items to include, and for each included grade item, a grade_grades entry's alteredaggregationweight and alteredaggregationstatus will be written out to the DB at least twice for each user. Once to reset it, and another time to update it. So a gradebook regrade is linear in the amount of grade_grades items present in the gradebook.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              szuta Patryk Szuta
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Matteo Scaramuccia, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              30 Vote for this issue
              Watchers:
              39 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: