ID searches way too slow
Description
CSP Request Details
None
CSP Rejection Details
None
Potential Workaround
None
blocks
is duplicated by
relates to
Checklist
hideTestRail: Results
Activity
Show:
Julian Ladisch September 5, 2019 at 2:31 PM
Pull request that has been merged: https://github.com/folio-org/cql2pgjson-java/pull/78
Jakub Skoczen January 9, 2019 at 12:04 PM
Sorry Julian, I meant the UUID searching issue. I have fixed my comment.
Julian Ladisch January 9, 2019 at 11:13 AM
This is not related.
Barcodes can contain letters: https://en.wikipedia.org/wiki/Barcode#Types_of_barcodes
Jakub Skoczen January 9, 2019 at 11:09 AMEdited
A problem, that seems very related to this issue – UUID searching using unaccent/lower, was reported by on #q4-perf channel. do we know why is seeing the problem? Is there a problem with the implementation in CQL2PG, mod-inventory-storarge?
Jakub Skoczen October 18, 2018 at 12:27 PM
Looks like this broke the client modules, e.g:
MODUSERS-94
MODUSERS-95
MODUSERS-96
Do we need more integration test to verify the behavior is not regressing before putting it out?
Done
Details
Details
Assignee
Heikki LevantoReporter
Heikki LevantoLabels
Priority
P3Development Team
Core: Platform
Fix versions
TestRail: Cases
Open TestRail: Cases
TestRail: Runs
Open TestRail: Runs
Created October 3, 2018 at 9:55 AM
Updated December 15, 2020 at 4:58 PM
Resolved October 11, 2018 at 9:20 AM
TestRail: Cases
TestRail: Runs
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.