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

Restoring a course with 400 users enrolled costs 13k DB queries

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.9
    • 1.9.1
    • Backup
    • None
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE

    Description

      Ouch, was just playing with a course with 400 users and restoring it cost 13k db queries!

      I quickly put a few mtraces in restore_create_users with $PERF->dbqueries and it seems to cost about 6000 queries on itself to end up not doing much.

      Attachments

        2. restorelib.php
          393 kB
          Pat B.

        Issue Links

          will be (partly) resolved by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-14269 META: Backup performance

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

          Activity

            People

              stronk7 Eloy Lafuente (stronk7)
              poltawski Dan Poltawski
              Petr Skoda Petr Skoda
              Adrian Greeve, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              3 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                15/May/08