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

Gradebook performance improvements for Moodle 3.1

    XMLWordPrintable

Details

    • MOODLE_28_STABLE
    • 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

              Unassigned Unassigned
              szuta Patryk Szuta
              Adrian Greeve, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie, Matteo Scaramuccia, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              30 Vote for this issue
              Watchers:
              38 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: