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
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 1.9, 1.9.1, 1.9.2
    • None
    • 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
              Matteo Scaramuccia, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, Safat Shahin, Tim Hunt, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie, Tim Hunt, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie, Huong Nguyen, Barbara Ramiro, Bas Brands, Mathew May, David Woloszyn, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: