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

Recent Activity block may be causeing big performance hit

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.9
    • Fix Version/s: None
    • Component/s: Performance
    • Labels:
      None
    • Affected Branches:
      MOODLE_19_STABLE

      Description

      Jos' Coelho reports in http://moodle.org/mod/forum/discuss.php?d=107478 that the queries made by the recent activity block cause a major server load when the log table becomes large.

      As this is a default block and many sites will choose to maintain logs for long periods of time, it may be a good idea to optimize this query or otherwise modify how it gets its information to improve performance.

      Jose' suggests that the difference in performance was like "night and day".

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              martinlanghoff Martín Langhoff
              Reporter:
              ganderson Gary Anderson
              Participants:
              Component watchers:
              Matteo Scaramuccia, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              7 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: