Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-38753

CLONE - Scores page load times excessive for large sites with assessments released to groups.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.6.x, 2.7.x, 2.8.x
    • Fix Version/s: 2.9.x
    • Component/s: Kernel
    • Labels:
      None
    • CLE Team Issue:
      Yes
    • Previous Issue Keys:
      SAM-1473, KNL-823

      Description

      We had a site where there were over 200 students and several site groups. Assessments were being released to those groups. We saw load times as much as 5 minutes to access the Total Scores page, but if the assessment was NOT released to a group, the Total Scores page loaded in a few seconds.

      The reason was that there was an inefficiency in how the code decided which users were supposed to be in the list for assessments released to groups. For each of the 200+ students, it had to do some DB checks to see if that student was a member of the group(s) the assessment was released to. That's 200+ individual queries where it could be done in one.

      I created a new method which returns the list of members who should be in a supplied list of site groups. This only requires a single query, and in our case it dramatically decreased the load time. I had to create a new method in the kernel for this.

      See attached patch.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  k1team KERNEL TEAM (Inactive)
                  Reporter:
                  dagnalpb Paul Dagnall
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration