Beginning an assessment will result in one query per POSSIBLE question
GENERAL
TESTING
GENERAL
TESTING
Description
1) Create 100 question pools with 100 questions each 2) Create assessment with 100 parts each with 1 question that pulls from a distinct pool 3) Publish assessment 4) Take assessment as student
Yourkit shows me that just beginning the assessment results in 100 * 100 queries
UNSTABLE: Integrated in sakai-trunk-java-1.7 #566 (See http://builds.sakaiproject.org:8080/job/sakai-trunk-java-1.7/566/) dont convert Sets to Lists in the Hibernate layer! This can result in tens of thousands of extra queries. This commit removes the getItemTextAttachmentList() helper method (ottenhoff@longsight.com: rev 315993)
Sam Ottenhoff December 11, 2014 at 9:31 AM
Basic regression testing needed especially around attachments added to items. Create assessment as instructor with attachments to items. Publish assessment. Take assessment as student. Confirm attachments are visible.
1) Create 100 question pools with 100 questions each
2) Create assessment with 100 parts each with 1 question that pulls from a distinct pool
3) Publish assessment
4) Take assessment as student
Yourkit shows me that just beginning the assessment results in 100 * 100 queries