Uploaded image for project: 'Samigo'
  1. Samigo
  2. SAM-3325

update SAM_ITEMGRADING_T multiplies as user progresses through long assessment

    Details

    • 12 status:
      Resolved
    • 11 status:
      Resolved
    • Test Plan:
      Hide

      Functional test:

      • Check that student answers continue to be saved while progressing through a test: create a 10 question test (one question per page), start taking it as a student, answer the first 5 questions then close browser without submitting. Open browser, login again as student, restart test, check that answers were saved.

      Performance test:

      • Check that response time does not decrease linearly when progressing through a large test.
      • Enable mysql query logging on db and count the number of UPDATE queries while progressing through a test.

      Load test:
      It would be something along these lines using selenium or other scripting tool in order to simulate large numbers of students taking a test at the same time (300-400). Google Testing Sheet

      Show
      Functional test: Check that student answers continue to be saved while progressing through a test: create a 10 question test (one question per page), start taking it as a student, answer the first 5 questions then close browser without submitting. Open browser, login again as student, restart test, check that answers were saved. Performance test: Check that response time does not decrease linearly when progressing through a large test. Enable mysql query logging on db and count the number of UPDATE queries while progressing through a test. Load test: It would be something along these lines using selenium or other scripting tool in order to simulate large numbers of students taking a test at the same time (300-400). Google Testing Sheet

      Description

      Stephen wrote to the list today:

      I think the total number of questions in the assessment is the issue here. If you graph database activity, you’ll see that the number of update queries increases as students progress through an assessment, because T&Q updates the scoring each time an item is saved and I suspect it updates every item in the assessment.

      For larger assessments (several hundred students), we’ve seen 1000+ update queries per second, and possibly your database cannot sustain that throughput.

        Gliffy Diagrams

          Attachments

          1. hibernate-use-merge.png
            hibernate-use-merge.png
            94 kB
          2. SAM-3325-11x.diff
            1 kB
          3. screenshot-1.png
            screenshot-1.png
            20 kB
          4. screenshot-2.png
            screenshot-2.png
            69 kB
          5. Screen Shot 2017-12-06 at 5.58.49 PM.png
            Screen Shot 2017-12-06 at 5.58.49 PM.png
            182 kB
          6. tf400generic.xml
            1.44 MB

            Activity

              People

              • Assignee:
                ottenhoff Sam Ottenhoff
                Reporter:
                smarquard Stephen Marquard
              • Votes:
                2 Vote for this issue
                Watchers:
                13 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: