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

ID searches way too slow

    XMLWordPrintable

    Details

    • Template:
    • Development Team:
      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

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

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases