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

forum_discussions requires index on course field

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide

      repeat testing from MDL-31089, you can limit it to test 2 and test 6 only (group and no-group modes)
      master only: verify upgrade to forum version 20140815 works and the index on forum_discussion (course) is created.

      Show
      repeat testing from MDL-31089 , you can limit it to test 2 and test 6 only (group and no-group modes) master only: verify upgrade to forum version 20140815 works and the index on forum_discussion (course) is created.
    • Affected Branches:
      MOODLE_26_STABLE, MOODLE_27_STABLE, MOODLE_28_STABLE
    • Fixed Branches:
      MOODLE_26_STABLE, MOODLE_27_STABLE
    • Pull Master Branch:
      wip-MDL-46826-master

      Description

      Occasionally, queries pop up which use forum_discussions.course as the filter condition, and join forum_posts and friends to fetch some data.

      This does not work very well as there is no index on the course field, so it results in quite poor queries.

      The latest case seems to be MDL-31089 which has made forum_print_overview a very serious bottleneck, found when testing 2.5 vs 2.7 performance.

      An index should be added to the course field to prevent these problems.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                marina Marina Glancy
                Reporter:
                tlevi Tony Levi
                Peer reviewer:
                Ankit Agarwal
                Integrator:
                Eloy Lafuente (stronk7)
                Tester:
                Andrew Nicols
                Participants:
                Component watchers:
                Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón, Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze, Matteo Scaramuccia, Jake Dallimore, Jun Pataleta
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  8/Sep/14