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

Add unique index to question_versions (questionbankentryid, version)

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 4.5.4, 5.0
    • Questions

      There are some performance issues related to the question_versions table (MDL-85637) that can be enhanced by adding an index for (questionbankentryid, version) columns.

      In addition to that, timhunt also pointed that "from a data integrity point-of-view, that should be a unique index"

            Unassigned Unassigned
            izendegi Iñigo Zendegi Urzelai
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:

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