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

performance improvement for get_users_in_context

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 3.6
    • 3.7
    • Privacy

    Description

      Reduce the number of joins in get_users_in_context where possible.

      there is no need to join on the context table when the context is either context_block, context_user or context_course because in those cases we already know that $context->instanceid is equal to $blockinstanceid, $userid or $courseid respectively.

      Attachments

        Issue Links

          Activity

            People

              rezaie9 Shamim Rezaie
              rezaie9 Shamim Rezaie
              Adrian Greeve Adrian Greeve
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              CiBoT CiBoT
              Andrew Lyons, Adrian Greeve, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                20/May/19