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

Adding one more index to mdl_question_state table would improve performance on big production sites

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Duplicate
    • Major
    • None
    • 1.9, 1.9.1, 1.9.2
    • None
    • Any
    • MOODLE_19_STABLE

    Description

      Our system admin found that if you add another index (using "originalquestion" field) to the mdl_question_states table, it would improve the quiz quite a lot if you are running a large moodle site. I would recommend this as default to create index with this field. Currently the default indexes that will be created by moodle installation script for this table are id (PRIMARY), attempt (mdl_quesstat_att_ix), and question (mdl_quesstat_que_ix). Thanks!

      Attachments

        Issue Links

          Activity

            People

              timhunt Tim Hunt
              chuang Wen Hao Chuang
              Nobody Nobody
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Clockify

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