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

Missing index on response_id questionnaire_resp_multiple

XMLWordPrintable

    • MOODLE_19_STABLE
    • MOODLE_19_STABLE, MOODLE_20_STABLE

      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.

        1. upgradequestionaire.patch
          2 kB

            mchurch Mike Churchward
            poltawski Dan Poltawski
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

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