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:
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.