Uploaded image for project: 'cql2pgjson'
  1. cql2pgjson
  2. CQLPG-58

ID searches way too slow

    XMLWordPrintable

Details

    • Core: Platform

    Description

      The current regexp search on id can take minutes on the 2.7m rec perf test set. Using a numerical search on the primary key runs in milliseconds. Make a special case for CQL2PG for id searches.

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Umbrella - CQLPG-59 Get rid of the regexp indexes and queries

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            New Feature - New feature requests UXPROD-1136 General tuning of Inventory search indexes

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            New Feature - New feature requests UXPROD-1427 General tuning of Inventory search indexes pt2

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            is duplicated by

            New Feature - New feature requests CQLPG-45 Use primary key for id searches

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. CQLPG-70 comparing id to invalid UUID: Don't throw error message, simply don't match

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            New Feature - New feature requests CQLPG-88 Implement id > [uuid] for pagination

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-146 Performance - POST and PUT for /inventory/items endpoint takes ~10 to ~15 seconds

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Umbrella - MODINVSTOR-166 Analyze and optimize search indexes

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODINVSTOR-181 Tune primary ID indexes

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODUSERS-95 Empty result for WHERE id='ba6baf95-bf14-4020-b44c-0cad269fb5c9'

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODUSERS-96 id="foo*" search results in QueryValidationException: CQL: Invalid UUID foo*

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. CQLPG-71 Allow /ignoreCase /masked /respectAccents for the primary key id field

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. RMB-277 id for primary key name, drop configuration option

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            New Feature - New feature requests RMB-468 Foreign key field index

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. UIU-681 QueryValidationException: CQL: only right truncation supported for id: *foo*

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Activity

              People

                heikki Heikki Levanto
                heikki Heikki Levanto
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases