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

user_bulk_download is highly inefficient database-wise

XMLWordPrintable

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

      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)?

            Unassigned Unassigned
            odyx Didier Raboud
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

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