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

Poor gradebook performance on first visit after upgrading to 2.9.1 on large sites

    XMLWordPrintable

    Details

    • Affected Branches:
      MOODLE_29_STABLE

      Description

      When we upgraded moodle.org to 2.9.1, when a teacher visits their gradebook for the first time the page is incredibly expensive to compute.

      URL	/grade/report/grader/index.php
      Date	7 July 2015, 11:22
      Execution time	172035.121 ms
      CPU time	97441.265 ms
      Function calls	50921045
      Memory used	19104 KB
      

      Attached xhprof profiling data - It looks like its doing 183,000 database queries.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              poltawski Dan Poltawski
              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:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated: