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

Gradebook history report performance issue on MySQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 2.8.9, 2.9.3, 3.0
    • Fix Version/s: None
    • Component/s: Gradebook
    • Labels:

      Description

      We've recently noticed this query in our slow logs running for hours. Our grade_grades_history table has over 9m records and this course in particular contributes 65k of them. The performance issues are because of nested sub-queries in the main query found in get_sql_and_params function in the tablelog.php class.

      We've modified the query to run under 4 minutes, not ideal but significantly better considering our scenario.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              smbader Steve Bader
              Peer reviewer:
              Simey Lameze
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              7 Vote for this issue
              Watchers:
              12 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: