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

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Duplicate
    • Component/s: moodle.org
    • Labels:
      None

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              nebgor Aparup Banerjee
              Participants:
              Component watchers:
              Helen Foster
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: