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

Slow queries : Index 'mdl_sess_tim2_ix' on table 'mdl_sessions' and column 'timemodified'

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Deferred
    • Icon: Minor Minor
    • None
    • 3.4, 3.5.5
    • General
    • MOODLE_34_STABLE, MOODLE_35_STABLE

      Hello,

      We have some slow queries on one of our Moodle platform.

      The 'mdl_sessions' table has ~5000 rows, and each time it's updated, this leads to a slow query (we think because of the index mdl_sess_tim2_ix (timemodified)).

      Why is there an index on timecreated and timemodified for this table ?

      Can we remove them ?

      Thank you in advance for you answer.

      Kind regards,

      Olivier

            Unassigned Unassigned
            Trolli Olivier Piton
            Votes:
            4 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved:

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