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

Add index for code column on the concept_reference_term table

    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