Dynamic quiz from incorrectly answered questions

Re: Dynamic quiz from incorrectly answered questions

by Michael Ko -
Number of replies: 0

Well I have achieved the feature by:

1. A local plugin to create a new quiz instance, similar to how the quiz unit test does it, and add the questions

2. Quiz access rule to ensure the "Retry" quiz can only be accessed by the user who made the original attempt

My questions are:

1. Will there be serious overall performance ramifications if a course has 10,000 quizzes (each year, and must retain them for 2+ years) containing an average of 60 questions? I know that Moodle does a lot of caching/operations on the courses

2. The quiz_slots table is going to jump from 16,000 rows to > 1 million, not to mention the impact on question attempt steps/data. I know that the quiz module is already quite database intensive. Will this cause any notable performance degradation? 

Thanks