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

user_bulk_download is highly inefficient database-wise

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Won't Do
    • 2.4.5
    • None
    • Administration
    • MOODLE_24_STABLE

    Description

      user_bulk_download isn't efficient enough to succeed in 30 seconds (default max_execution_time) here. Apparently it does two DB requests for each user (one in the user_download_$format and one in profile_load_data), which results in 13.2k queries for the 6629 users that we have on the instance that fails here.

      The temporary workaround is to set: php_admin_value max_execution_time 240

      (2-3 minutes is what it takes still).

      Isn't it possible to do it in one or two queries (eventually paging per 1000 users to not get too huge answer arrays)?

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              odyx Didier Raboud
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: