Uploaded image for project: 'stripes-components'
  1. stripes-components
  2. STCOM-492

Change filter search cql syntax to use == not =

    XMLWordPrintable

Details

    • Tech Debt
    • Status: Closed (View Workflow)
    • P2
    • Resolution: Done
    • None
    • 8.0.0
    • None
    • CP: ready for planning, Core: F - Sprint 93, Core: F - Sprint 94, Core: F - Sprint 95, Core: F - Sprint 96, Core: F - Sprint 97, Core: F - Sprint 98, Core: F - Sprint 99
    • 0.5
    • Prokopovych
    • Q3 2020

    Description

      The "=" syntax is translated to ~ regex search on database side and is very slow. Since filters search the exact key, we should use "==" syntax that translates to LIKE (equivalent to exact in most cases) and that is way faster. For example in location filtered instance search, we see performance improved about 30x.

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                SergiySergiyenko Sergiy Sergiyenko
                hji Hongwei Ji
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases