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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 1.9.1
    • 1.9
    • Backup
    • None
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE

      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.

        1. restorelib.php
          393 kB
          Pat B.

            stronk7 Eloy Lafuente (stronk7)
            poltawski Dan Poltawski
            Petr Skoda Petr Skoda (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.