Details
-
Bug
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
2.2.3
-
-
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
-
CQLPG-59 Get rid of the regexp indexes and queries
-
- Closed
-
-
UXPROD-1136 General tuning of Inventory search indexes
-
- Closed
-
-
UXPROD-1427 General tuning of Inventory search indexes pt2
-
- Closed
-
- is duplicated by
-
CQLPG-45 Use primary key for id searches
-
- Closed
-
- relates to
-
CQLPG-70 comparing id to invalid UUID: Don't throw error message, simply don't match
-
- Closed
-
-
CQLPG-88 Implement id > [uuid] for pagination
-
- Closed
-
-
MODINVSTOR-146 Performance - POST and PUT for /inventory/items endpoint takes ~10 to ~15 seconds
-
- Closed
-
-
MODINVSTOR-166 Analyze and optimize search indexes
-
- Closed
-
-
MODINVSTOR-181 Tune primary ID indexes
-
- Closed
-
-
MODUSERS-95 Empty result for WHERE id='ba6baf95-bf14-4020-b44c-0cad269fb5c9'
-
- Closed
-
-
MODUSERS-96 id="foo*" search results in QueryValidationException: CQL: Invalid UUID foo*
-
- Closed
-
-
CQLPG-71 Allow /ignoreCase /masked /respectAccents for the primary key id field
-
- Closed
-
-
RMB-277 id for primary key name, drop configuration option
-
- Closed
-
-
RMB-468 Foreign key field index
-
- Closed
-
-
UIU-681 QueryValidationException: CQL: only right truncation supported for id: *foo*
-
- Closed
-