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

Overview page generates too many queries leading to performance issues

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.4.0, 2.4.1, 2.4.x, 2.5.0
    • Fix Version/s: 2.5.2, 2.6.0
    • Component/s: Section Info
    • Labels:
      None

      Description

      We have repeatedly seen performance issues arising from section signup in large course sites with many sections. One case we have has approx 1400 students and 103 sections.

      In this site, a student displaying the Overview page generates 2793 select queries which involve SAKAI_REALM* tables. This is simply unscaleable, especially in circumstances where instructors advertise that section signup will begin at a particular time, and hundreds of students login simultaneously and refresh the overview page until section signup is enabled.

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                jholtzman Josh Holtzman (Inactive)
                Reporter:
                smarquard Stephen Marquard
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration