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

Quiz delivery generates excessive queries

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Critical
    • Resolution: Incorporated
    • Affects Version/s: 2.8.3, 2.8.4 [Tentative], 2.9.0
    • Fix Version/s: None
    • Labels:
    • Previous Issue Keys:
      SAM-1523

      Description

      During the final exams in November 2011 a instructor tried to deliver a test to 200 students that consisted of 400 questions. The students experienced high error rates and worsening response as the test progressed. Monitoring showed a large number of queries and hight TTFB.

      Analysis of the queries generated when the test is taken show that the number of queries generated as a student continues from one question to the next progressively increases as the test continues:

      questions 20 - 40 generated 353 per question
      100 - 120 1064/Q
      150 - 170 1501/Q
      200 - 220 1940/Q
      350 - 370 3294/Q
      370 - 400 3520/Q
      Submit step generated 9422 queries
      Total queries:760657 (average 1901 queries per question)

      (using the EMI branch on samigo trunk)

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  samigoteam SAMIGO TEAM (Inactive)
                  Reporter:
                  dhorwitz David Horwitz
                • Votes:
                  2 Vote for this issue
                  Watchers:
                  9 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code