Details
-
Bug
-
Status: Closed (View Workflow)
-
P4
-
Resolution: Done
-
14.0.0, 15.4.0
-
customfield_11100 22900
-
CP: sprint 64
-
2
-
Core: Platform
Description
The performance test https://github.com/folio-org/folio-perf-test/blob/ad414b0/Folio-Test-Plans/mod-inventory-storage/instance-storage/instance-storageTestPlan.jmx#L290
running /instance-storage/instances?query=source=abc takes 360 seconds on average.
There is no index for the source field resulting in a full table scan.
Other fields like title have a full text index and are fast (?query=title=abc).
Solution:
- If there a possibility in the front-end to run such a query? If not I suggest to change the performance test to query the title instead of the source field. And to close this issue as won't do.
- Otherwise: add fulltextext index for the source field
TestRail: Results
Attachments
Issue Links
- relates to
-
MODINVSTOR-246 filtering /instance-storage/instances by 'query=id=xxx' does not perform
-
- Closed
-
-
MODINVSTOR-256 Improve performance of /instance-storage/instances?query=holdingsRecords.permanentLocationId=abc*
-
- Closed
-