Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-1347

Missing index on response_id questionnaire_resp_multiple

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.4
    • Fix Version/s: 1.9.4, 2.0
    • Component/s: Module: Questionnaire
    • Labels:
      None
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE, MOODLE_20_STABLE

      Description

      All the questionnaire response types have indexes on the response_id field apart from questionnaire_resp_multiple.

      Attached is a patch to add this index with other response tables.

      By adding this index, a query selecting all responses went from 17minutes long to 4seconds.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              mchurch Mike Churchward
              Reporter:
              poltawski Dan Poltawski
              Participants:
              Component watchers:
              Mike Churchward
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                28/Jan/09