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

          Discovered while testing

          Task - A task that needs to be completed. Tasks usually refer to work that must be done outside the product. MDLSITE-4100 Upgrade moodle.org to 2.9.1

          • Low - Cosmetic problems, nice-to-have features
          • Resolved
          has a non-specific relationship to

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-51498 Improve performance for regrading gradebook

          • Blocker - Blocks development and/or testing, prevents Moodle from running (applicable to bugs only)
          • Closed
          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-50589 External gradereport_user::get_grades_table should regrade

          • Minor - Minor loss of function where workaround is possible
          • Closed

          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, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              2 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: