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

        Issue Links

          Activity

            People

              stronk7 Eloy Lafuente (stronk7)
              poltawski Dan Poltawski
              Petr Skoda Petr Skoda
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski
              Votes:
              3 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                15/May/08