Investigate and improve loan query performance

Description

During BugFestq3.2-2019 testing, noticed that the loans query take over one second. See blow for the log line. See attachment for the full Okapi

log.

We need to investigate in more details what calls are triggered by the above API call. Please attach appropriate logs.

Environment

None

Potential Workaround

None

Attachments

1

Checklist

hide

TestRail: Results

Activity

Show:

Eric ValukSeptember 24, 2019 at 1:31 PM

I do see some mod-perm calls. I cannot be certain if they are related though.

Jakub SkoczenSeptember 24, 2019 at 8:50 AM

do we have a release of mod-at with MODAT-50? If so, can we get it updated on the BugFest env?

Hongwei JiSeptember 23, 2019 at 3:59 PM

The cache miss should cause a call to mod-perms. Do we see related timing on mod-perms? It might be helpful if we can release and deploy 's fix to mod-authtoken so request id can be passed properly and show up in the log.

Eric ValukSeptember 23, 2019 at 3:48 PM

It appears that yet again mod-authtoken figures prominently in this request. this line:
468917/circulation;875910/loan-storage RES 202 278078 mod-authtoken-2.2.1 http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/loan-storage/loans?query=(userId=a7f483c5-8cd4-46cf-9a56-1430ec2514cc%20and%20status.name%3C%3EClosed)&limit=1

takes 279ms and this line:

468917/circulation;829541/holdings-storage RES 202 192816 mod-authtoken-2.2.1 http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/holdings-storage/holdings?query=id%3D%3D%28%22dd00837f-d9be-4357-8f54-a9d2b19770d9%22%29&limit=2147483647&offset=0

takes 192ms

of note here is that mod-at does not ALWAYS seem to take a long time even for this same module. I would hypothesize a cache miss or some other cache behavior is causing this issue.

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Core: Platform

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created September 23, 2019 at 1:33 PM
Updated October 1, 2019 at 1:29 PM
Resolved September 24, 2019 at 1:48 PM
TestRail: Cases
TestRail: Runs