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

Assignment print course overview query performance

    XMLWordPrintable

Details

    • MOODLE_23_STABLE
    • MOODLE_23_STABLE, MOODLE_24_STABLE
    • git@github.com:damyon/moodle.git
    • MDL-37527-master
    • Hide

      This is a performance improvement, so not really testable - just check for regressions.

      1. In a course create 3 assignments with file submissions enabled
      2. Login as a student and upload a file submission to each assignment
      3. View the "My home" page for the student (has the course_overview block by default).
      4. Verify there are no reported errors
      5. Login as a teacher for the same course
      6. View the "My home" page for the teacher.
      7. Verify there are no reported errors
      Show
      This is a performance improvement, so not really testable - just check for regressions. In a course create 3 assignments with file submissions enabled Login as a student and upload a file submission to each assignment View the "My home" page for the student (has the course_overview block by default). Verify there are no reported errors Login as a teacher for the same course View the "My home" page for the teacher. Verify there are no reported errors

    Description

      The query in question is the one to get all user submissions. Please see attached fix, without it indexes are not used.

      Attachments

        Issue Links

          Activity

            People

              damyon Damyon Wiese
              bushido Mark Nielsen
              Dan Poltawski Dan Poltawski
              Ankit Agarwal Ankit Agarwal
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Matteo Scaramuccia, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                11/Mar/13