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

          has a non-specific relationship to

          Improvement - An enhancement to an existing Moodle feature. MDL-36941 Create new tables for messages and notifications and convert existing API to use these

          • Major - Major loss of function, incorrect output
          • Closed
          has been marked as being related by

          Improvement - An enhancement to an existing Moodle feature. MDL-50805 Cron Messaging Cleanup Task very slow due to lack of field indexing

          • Minor - Minor loss of function where workaround is possible
          • Closed

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: