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

Performance fixes for some providers

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 3.3.5, 3.4.2, 3.5
    • 3.3.6, 3.4.3
    • Privacy

    Description

      We've discovered some issues due to joins which don't scale well with large numbers of records.

      The one which we discovered this with is assign and it's because the query planner in some engines doesn't deal well with joins where the filter is only in the WHERE (when it should be on the JOIN).

      Thankfully this only effects providers, and only those which do complex joins, and thankfully these are mostly extremely well unit tested now.

      Attachments

        Activity

          People

            dobedobedoh Andrew Lyons
            dobedobedoh Andrew Lyons
            Adrian Greeve Adrian Greeve
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            CiBoT CiBoT
            Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              17/May/18