-
Bug
-
Resolution: Fixed
-
Major
-
2.6, 2.6.3, 2.7
-
MOODLE_26_STABLE, MOODLE_27_STABLE
-
MOODLE_26_STABLE, MOODLE_27_STABLE
-
MDL-39726-master -
Question restoration in backup/moodle2/restore_stepslib.php has the following function;
/**
|
* Execution step that will create all the question/answers/qtype-specific files for the restored
|
* questions. It must be executed after {@link restore_move_module_questions_categories}
|
* because only then each question is in its final category and only then the
|
* context can be determined
|
*
|
* TODO: Improve this. Instead of looping over each question, it can be reduced to
|
* be done by contexts (this will save a huge ammount of queries)
|
*/
|
class restore_create_question_files extends restore_execution_step {
|
|
protected function define_execution() {
|
That TODO is causing issues with large question bank restoration. The loop of questions adds lots of backwards and forwards latency and query parsing time to the restore process when talking to the database.
This issue has been created to address the TODO item as it's been raised and discussed in MDL-29439.
This is considered an Improvement as it's an alteration to the Question restore on a sufficiently large scale that it would not be particularly safe to back-patch. Especially given that it's still possible to restore large quizzes in previous versions.
- Discovered while testing
-
MDL-45977 System questions are restored to incorrect category
- Closed
- has a non-specific relationship to
-
MDL-39725 PostgreSQL performance can be poor with large temp tables
- Closed
- has been marked as being related by
-
MDL-40579 Restore performance improvements
- Closed
-
MDL-44813 restoring courses in 2.6.1 very slow
- Closed
- is duplicated by
-
MDL-40169 modduplicate causing apache to crash when copying quiz
- Closed
- will help resolve
-
MDL-12403 backup or import of single quiz includes all questions in database
- Closed
-
MDL-29439 Quiz restoration is very slow if the backup contains lots of questions
- Closed