Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-8157

Improve performance on view

XMLWordPrintable

    • MOODLE_39_STABLE

      Add index (courseid) to bigbluebuttonbn_logs

      After running a very busy moodle site with a lot of BBB activities(more than 2000 simultaneous users in conferences) I realized that when users try to join conferences the following SQL query is performed:
      SELECT COUNT from bigbluebuttonbn_logs WHERE courseid ...
      This query consumes a lot of CPU time on the SQL server (MariaDB) making the database to respond very slow. Adding the proposed index (courseid) made a huge difference.

      Partialy covered by PR#235

            jfederico Jesus Federico
            jfederico Jesus Federico
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

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