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

Improve performance of Online users block

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.2.11, 2.3.9, 2.4.6, 2.5.2, 2.7.7, 2.8.5, 2.9.1, 3.0
    • 3.0
    • Blocks
    • MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE, MOODLE_25_STABLE, MOODLE_27_STABLE, MOODLE_28_STABLE, MOODLE_29_STABLE, MOODLE_30_STABLE
    • MOODLE_30_STABLE
    • MDL-41944_block_online_users_perf
    • Hide

      Add the online users block to a page. Simulate logged in users by logging in as a few different users using separate browsers/computers. Verify that all logged in users still appear in the block.

      Try the above when filtering on a group is effective (in a course with separated groups forced, logged in as student). Verify that all recently logged in users who are part of the student group still appear in the block while others are not.

      Run unit tests against all DBs.

      Show
      Add the online users block to a page. Simulate logged in users by logging in as a few different users using separate browsers/computers. Verify that all logged in users still appear in the block. Try the above when filtering on a group is effective (in a course with separated groups forced, logged in as student). Verify that all recently logged in users who are part of the student group still appear in the block while others are not. Run unit tests against all DBs.

    Description

      The online users block uses MAX + GROUP BY when it is not needed. A significant performance gain can be achieved by fixing this.

      Attachments

        Issue Links

          Activity

            People

              barrysspace Barry Oosthuizen
              barrysspace Barry Oosthuizen
              John Okely John Okely
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Adrian Greeve Adrian Greeve
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Sujith Haridasan
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                16/Nov/15