Details
-
Bug
-
Status: Closed (View Workflow)
-
P2
-
Resolution: Done
-
None
-
-
Folijet
Description
During testing loading items on instance record (in holdings accordion) the next slow query has been captured:
EXPLAIN ANALYZE select get_record_by_external_id('89a7ec1c-608f-4d24-90b6-57da21557874', 'instanceId');
Steps to Reproduce:
- Log into performance environment as folio user
- Get formatted records using curl for example
curl -i --verbose --request GET 'https://okapi-fcp1.int.aws.folio.org:443/source-storage/formattedRecords/89a7ec1c-608f-4d24-90b6-57da21557874?identifier=INSTANCE' \ > --header 'x-okapi-tenant: fs09000000' \ > --header 'x-okapi-token: ${xokapi-token}' \ > --header 'Content-Type: application/json'
Expected Results: query should return records < 20 ms
Actual Results: 2650.877 ms
Additional Information:
URL: https://wiki.folio.org/display/FOLIJET/Loading+items+on+instance+record+%28in+holdings+accordion%29+Test+Report
Interested parties:
Everyone
TestRail: Results
Attachments
Issue Links
- defines
-
MODSOURCE-121 Improve performance for receiving records from SRS
-
- Closed
-
-
UXPROD-2363 SRS Performance Improvements
-
- Closed
-
- relates to
-
PERF-40 Loading items on instance record (in holdings accordion) is slow
-
- Closed
-