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