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

Concept name searches uses the slower ilike

    XMLWordPrintable

    Details

    • Complexity:
      Low

      Description

      The concept_word table stores text in all upper case. The concept search that searches concept work does a lower() and then uses the case insensitive ilike search. This is a inefficient.

      Instead, all search strings should be upper-cased and the search switched to a simple like.

      Also when the searchOnPhrase parameter is null, we need to do an equals instead of a like. This will lead to better performance as well.

        Attachments

          Activity

            People

            Assignee:
            raff Rafal Korytkowski
            Reporter:
            bwolfe Ben Wolfe
            Votes:
            6 Vote for this issue
            Watchers:
            8 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 4 hours Original Estimate - 4 hours
                4h
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day
                1d