[SAK-38439] Samigo > improve performance when copying questions from pool to quiz Created: 25-Apr-2018  Updated: 30-May-2018  Resolved: 22-May-2018

Status: Verified
Project: Sakai
Component/s: Tests & Quizzes (Samigo)
Affects Version/s: 11.4
Fix Version/s: 11.5 [Tentative], 12.2, 19.0

Type: Feature Request Priority: Critical
Reporter: Brian Jones Assignee: Brian Jones
Resolution: Fixed Votes: 0
Labels: performance

12 status: Resolved
11 status: Resolved
Test Plan:
  • Create some questions in a pool
  • Copy from the pool to a quiz

Questions should appear quickly in a new quiz


The performance of copying questions from a question pool to a quiz is a little sluggish. In our testing, using a question pool of 25 questions, it took an average of ~19000 ms to copy all 25 questions from the pool to a quiz. The larger the number of questions imported, the longer it takes.

After the PR is applied, this same process using the same site, same quiz, and same 25 questions from the question pool reduced the processing time to an average of ~2800 ms.

Comment by Daniel Merino Echeverría [ 28-May-2018 ]

I have done a backport of this patch for our 11.4 and have submitted a PR against 11.x branch.

Comment by Matthew Jones [ 29-May-2018 ]

Could we get a verification on the test plan that this is still working as expected on nightly? Then we'll merge this and the 11.x one back. Ideally we'll get the Sakai 11 also tested.

Comment by Daniel Merino Echeverría [ 30-May-2018 ]

I have tested this in https://trunk-mysql.nightly.sakaiproject.org/portal/

A question pool of 30 quizzes has been copied into a new test in about 5 seconds.

Comment by Matthew Jones [ 30-May-2018 ]

Thanks Daniel Merino Echeverría, I merged your PR to 11 and picked this back to 12.x.

Generated at Thu Jun 04 19:40:17 CDT 2020 using Jira 8.0.3#800011-sha1:073e8b433c2c0e389c609c14a045ffa7abaca10d.