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

Activity reports (outline and complete) are very slow

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.6, 1.9
    • Fix Version/s: 1.9
    • Component/s: Administration
    • Labels:
      None
    • Environment:
      All
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_16_STABLE, MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      With a busy site there are a lot of rows in the log table, and the activity report does a lot of WHEREs that are hitting unindexed columns.

      Index the mdl_logs table column info and watch the magic of Outline report It's faster by several orders of magnitude. The extra index adds less overhead than one (at least I) would think.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              skodak Petr Skoda
              Reporter:
              samulik Samuli Karevaara
              Tester:
              Nobody
              Participants:
              Component watchers:
              Andrew Nicols, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                3/Mar/08