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
              Votes:
              2 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: