Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-626

Clean up database index for PostgreSQL and Oracle

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 9.0.0
    • Component/s: Database
    • Labels:
      None

      Description

      The idea is to rewrite the part of the setupDatabase.sql related to index and foreign keys. MySQL create by default an index for every foreign key. For PostgreSQL and Oracle, it's best practice to do it but the databases won't do it automatically.

      The task is in three parts:
      1. Reorder the list of foreign keys and index per tables for all 3 databases.
      2. Add an index for every foreign keys
      3. Add missing index to the update script of PostgreSQL and Oracle

        Attachments

          Activity

            People

            • Assignee:
              srosse Stéphane Rossé
              Reporter:
              gnaegi Florian Gnägi
              Tester:
              Joël Krähemann
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: