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

Add index for code column on the concept_reference_term table

    XMLWordPrintable

    Details

    • Complexity:
      Low

      Description

      It's often useful to search for concepts using a mapping when working at API level (i.e. Context.getConceptService().getConceptByMapping(...)). This type of query is necessary for any modules that need to deal with standardized terminology.

      However the code column on the concept_reference_term table isn't indexed. Adding this index would be of huge benefit for optimizing the getConceptByMapping query.

        Attachments

          Activity

            People

            Assignee:
            hannes Hannes Venter [X] (Inactive)
            Reporter:
            hannes Hannes Venter [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 1 hour
                1h
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour
                1h