ID searches way too slow

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.

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Checklist

hide

TestRail: 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 AM
Edited

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

Assignee

Reporter

Priority

Development 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
Loading...