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

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

    XMLWordPrintable

Details

    • Task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.8
    • 1.8.3, 1.9
    • Database SQL/XMLDB
    • None
    • Any
    • MySQL, PostgreSQL
    • MOODLE_18_STABLE
    • 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

              stronk7 Eloy Lafuente (stronk7)
              stronk7 Eloy Lafuente (stronk7)
              Nobody Nobody
              Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                11/Oct/07