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

    • 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

              Unassigned Unassigned
              poltawski Dan Poltawski
              Adrian Greeve, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie, Matteo Scaramuccia, David Woloszyn, Huong Nguyen, Jake Dallimore, Michael Hawkins, Stevani Andolo
              Votes:
              2 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated: