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

Slow log report on user / action due to lack of index

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.2.5, 3.3.2
    • Fix Version/s: None
    • Labels:
      None
    • Affected Branches:
      MOODLE_32_STABLE, MOODLE_33_STABLE

      Description

      The log report is extremely slow for large sites when filtering by user + action. This is because there are no indexes on logstore_standard_log that can be used.

      It would be good to add the necessary indexes to ensure that any filtering done in the log report makes use of indexes.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              maherne Michael Aherne
              Participants:
              Component watchers:
              Jake Dallimore, Jun Pataleta, Ryan Wyllie, Jake Dallimore, Jun Pataleta, Ryan Wyllie
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: