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

SCORM scorm_scoes_track index on element is massive and unsused


      The scorm_scoes_track table has an index on the "element" field that doesn't appear to be used at all - and is quite large in some of our larger sites.

      For example - the query here:

      Returns results like:
      Table size: 4604MB
      Index size: 1705MB
      number_of_scans: 0

      We do have a couple of sites that have less than 10 scans on the index. But the impact of having to maintain this index, the lack of use (and the disk usage) suggests we should be deleting this index.

      The longer-term plan is to address: MDL-46279 but in the short-term I think we should drop this index.

            danmarsden Dan Marsden
            danmarsden Dan Marsden
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            0 Vote for this issue
            4 Start watching this issue


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