Uploaded image for project: 'OpenMRS Core'
  1. OpenMRS Core
  2. TRUNK-4743

Create missing database indexes

    XMLWordPrintable

    Details

    • Complexity:
      Low

      Description

      There is a lot of calls to AdministrationService.getGlobalProperty(String) all over the system, but we do not have an index on the property field so those calls are very slow. An index for global_property.property must be created.

      Other missing indexes discovered while profiling the openconceptlab module, which imports concepts are:
      concept_class.name
      concept_datatype.name
      concept_reference_term.uuid

      I think we should create indexes for them as well.

      Add indexes in liquibase-update-to-latest.xml. Each index must be a separate changeset.

        Gliffy Diagrams

          Attachments

            Activity

              People

              Assignee:
              sns.recommind Stefan Neuhaus
              Reporter:
              raff Rafal Korytkowski
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1 day
                  1d
                  Remaining:
                  Time Spent - 2 hours Remaining Estimate - 6 hours
                  6h
                  Logged:
                  Time Spent - 2 hours Remaining Estimate - 6 hours
                  2h