Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-29439

Quiz restoration is very slow if the backup contains lots of questions

    XMLWordPrintable

Details

    • Any
    • MOODLE_21_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE

    Description

      When restoring a backup (Moodle 2 mbz) containing 120 quizzes it takes a long time to complete the restore. To restore the previous course it took 10 minutes on a 4 processor, 16 GB RAM MySQL Database Server.

      When the subject was backed up and restored in a Moodle 1.9 environment the restore takes 2 minutes.

      We can provide 10 backup samples but not on this public tracker. This is due the presence of copyrighted documents in the backup.

      Attachments

        Issue Links

          has a non-specific relationship to

          Sub-task - Issues are sometimes broken into multiple sub-tasks. MDL-27120 Backup / Restore / Import performance optimisations

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-26442 Error when importing quiz with system level questions from Moodle 2.0 course (which was imported from 1.9) to another Moodle 2.0 course on the same site

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed
          has been marked as being related by

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDL-40579 Restore performance improvements

          • Major - Major loss of function, incorrect output
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-39725 PostgreSQL performance can be poor with large temp tables

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-44813 restoring courses in 2.6.1 very slow

          • Minor - Minor loss of function where workaround is possible
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-35340 B&R or importing course with large question bank failed on IIS

          • Minor - Minor loss of function where workaround is possible
          • Closed
          will be (partly) resolved by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-39726 Question restoration should not use a loop over questions, it can be done once per context

          • Major - Major loss of function, incorrect output
          • Closed

          Improvement - An enhancement to an existing Moodle feature. MDL-40581 backupidsexists and backupidscache could be used more effectively

          • Minor - Minor loss of function where workaround is possible
          • Development in progress

          Activity

            People

              Votes:
              31 Vote for this issue
              Watchers:
              27 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: