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

Concept name searches uses the slower ilike

    XMLWordPrintable

Details

    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.

      Gliffy Diagrams

        Attachments

          Activity

            People

              raff Rafal Korytkowski
              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