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.

        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