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

Review all the indexes, creating the missing ones...

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.8
    • Fix Version/s: 1.8.3, 1.9
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      Any
    • Database:
      MySQL, PostgreSQL
    • Affected Branches:
      MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_18_STABLE, MOODLE_19_STABLE

      Description

      With the introduction of XMLDB a lot of "foreign key" obvious missing indexes have been added to Moodle DB Schema.

      So, new sites created under 1.7 will have some more indexes than old sites migrated from previous versions (non XMLDB stuff).

      At some moment in HEAD we must add some utility to look for indexes, compare them with the needed by the XMLDB schema and build them as necessary.

      This can be achieved by the upgrade script or by some special script somewhere (Health Center) in the Admin Interface.

      The script should iterate over all the Moodle XMLDB structures, getting their indexes and looking in DB if they are present (not matter of their name), creating them if necessary.

      Only MySQL and PostgreSQL will need this.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  11/Oct/07