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

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

      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!

            timhunt Tim Hunt
            chuang Wen Hao Chuang
            Nobody Nobody (Inactive)
            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.