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

Recent Activity block may be causeing big performance hit

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 1.9
    • None
    • Performance
    • None
    • 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

              martinlanghoff Martín Langhoff
              ganderson Gary Anderson
              Matteo Scaramuccia, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              7 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: