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

Bulk upload user form costs 16,000 database queries with 165 users course/group enrolments

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Won't Fix
    • 1.9.4
    • None
    • Performance
    • None
    • MOODLE_19_STABLE

    Description

      I have some sample data & when uploading 165 user records with this sort of thing:

      username,course1,course2,course3,course4,course5,group1,group2,group3,group4,group5
      myusername,9.1,9.2,9.3,9.4,9.5,9H,9H,9H,9H,9H
      myusername2,9.1,9.2,9.3,9.4,9.5,9H,9H,9H,9H,9H

      Its costing 16,000 database queries. This makes the upload unusuable.

      Need to investigate and improve what is causing this.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              poltawski Dan Poltawski
              Matteo Scaramuccia, David Woloszyn, Huong Nguyen, Jake Dallimore, Michael Hawkins, Stevani Andolo
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: