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

              • Votes:
                7 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: