Uploaded image for project: 'Moodle Community Sites'
  1. Moodle Community Sites
  2. MDLSITE-3051

first cron after 2.7 upgrade moodle.org has slow inefficient query against message_read table

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Low Low
    • moodle.org
    • None

      upon upgrades on next.moodle.org as well as moodle.org we faced a apparently one time issue
      // Cleanup messaging.
      + if (!empty($CFG->messagingdeletereadnotificationsdelay)) {
      + $notificationdeletetime = $timenow - $CFG->messagingdeletereadnotificationsdelay;
      + $params = array('notificationdeletetime' => $notificationdeletetime);
      + $DB

      the query above took too long. This will mainly be an MDL issue i suppose but its here incase we need to optimise anything on moodle.org & out other sites

            Unassigned Unassigned
            nebgor Aparup Banerjee
            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.