Details
-
Type:
Bug
-
Status: Verified
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 11.4
-
Fix Version/s: 11.5 [Tentative], 12.0, 19.0
-
Component/s: Tests & Quizzes (Samigo)
-
Labels:
-
12 status:Resolved
-
11 status:Resolved
-
Previous Issue Keys:SAM-3325
-
Test Plan:
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
Zeplin
Attachments
Issue Links
- is related to
-
SAK-39928 Samigo > minimize redundant UPDATE queries on SAM_ITEMGRADING_T
-
- Verified
-