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

Check and update Privacy Provider queries to improve performance

    XMLWordPrintable

    Details

    • Type: Epic
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.5.3, 3.6.1, 3.7
    • Fix Version/s: None
    • Component/s: Privacy
    • Labels:
      None
    • Affected Branches:
      MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE

      Description

      We need to check all of our privacy providers calls to add_from_sql to reduce their complexity. Many of these have a large number of LEFT JOINs when we should (in hindsight) have created them with a large number of queries with INNER JOINs.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              dobedobedoh Andrew Nicols
              Participants:
              Component watchers:
              Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: