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

Create missing database indexes

    XMLWordPrintable

Details

    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

              sns.recommind Stefan Neuhaus
              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