Details
-
Bug
-
Status: Closed
-
Must
-
Resolution: Fixed
-
Platform 1.9.9, Platform 1.10.2, Platform 1.11.3
-
None
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.