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

Tags block should cache the tags cloud SQL results

    XMLWordPrintable

Details

    • MOODLE_39_STABLE

    Description

      We are experiencing performance issues with the Tags block on moodle.org where we use a single tags collection (users' interests) with a few tens of thousands tags and tag instances.

      The block calls core_tag_collection::get_tag_cloud() on every single page load and generating the tags cloud take a significant time (we suspect due to sorting involved).

      This represents a potential surface for a DoS attack on bigger sites with many tags using the block.

      It is apparent that the block could cache the results for a while instead of populating the same aggregated cloud over and over again.

      Attachments

        Activity

          People

            Unassigned Unassigned
            mudrd8mz David Mudrák (@mudrd8mz)
            David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, Matteo Scaramuccia, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
            Votes:
            2 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: