Uploaded image for project: 'Opencast'
  1. MH-9202

The database scripts do not contain the relevant index definitions

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed and reviewed
    • Affects versions: 1.4.0
    • Fix versions: 1.4.0
    • Components: Backend Software
    • Labels:
      None
    • Severity:
      Performance
    • Steps to reproduce:
      Hide
      Steps to reproduce:

      1. Reports have been reaching the community about databases not performing well anymore due to major amounts of data produced by Matterhorn.
      2. Looking at the database scripts, there are many tables that do not define indices, thereby forcing database engines to do massive table scans

      We need to review the database scripts and compare them with the SQL queries defined through JPA to determine JOIN conditions, WHERE clauses and other construct that may profit from database indices.
      Show
      Steps to reproduce: 1. Reports have been reaching the community about databases not performing well anymore due to major amounts of data produced by Matterhorn. 2. Looking at the database scripts, there are many tables that do not define indices, thereby forcing database engines to do massive table scans We need to review the database scripts and compare them with the SQL queries defined through JPA to determine JOIN conditions, WHERE clauses and other construct that may profit from database indices.
    • Tags (folksonomy):

      TestRail: Results

        Attachments

        1. update-mysql.sql
          11 kB
        2. update-mysql v2.sql
          12 kB
        3. update-mysql v3.sql
          12 kB
        4. update-postgresql.sql
          11 kB
        5. update-postgresql v2.sql
          11 kB

          Issue links

            Activity

              People

              • Assignee:
                twunden Tobias Wunden
                Reporter:
                twunden Tobias Wunden
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  TestRail: Cases