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:
            Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona)
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: