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

Assignment print course overview query performance

    XMLWordPrintable

    Details

    • Testing Instructions:
      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
    • Affected Branches:
      MOODLE_23_STABLE
    • Fixed Branches:
      MOODLE_23_STABLE, MOODLE_24_STABLE
    • Pull from Repository:
      git@github.com:damyon/moodle.git
    • Pull Master Branch:
      MDL-37527-master

      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

              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  11/Mar/13