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

performance improvement for get_users_in_context (take #2)

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.7
    • 3.7
    • Performance, Privacy

      This is a followup of MDL-63785 where a good number of privacy queries were simplified to avoid joining with the contexts table when the contexts being searched are block, course or user. Simply because the instanceid of those contexts that we are fetching now is, already, the block, course or user id that we have in the different tables.

      This issue is about to look for remaining cases (some were detected in the original issue, there may be more) to follow the same simplification approach if the original one is accepted.

      Ciao

            rezaie9 Shamim Rezaie
            stronk7 Eloy Lafuente (stronk7)
            Michael Hawkins Michael Hawkins
            David Monllaó David Monllaó
            CiBoT CiBoT
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 days, 4 hours
                2d 4h

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.