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

Add index to timeread column of mdl_message_read table

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.2.4
    • Fix Version/s: None
    • Component/s: Messages
    • Labels:
    • Affected Branches:
      MOODLE_22_STABLE

      Description

      There seems to be a cron function which removes old read messages based upon timeread value, but this column is not indexed. Please index to improve performance of this regular function.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              dakota.duff Dakota Duff
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona)
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: