Status: Closed (View Workflow)
Affects Version/s: 5.0.9
Fix Version/s: 6.0.0
Template:Standard Bug Write-Up Format customfield_11100 44597
Sprint:Prokopovych - Sprint 109, Prokopovych - Sprint 110
Release:R1 2021 Bug Fix
Affected Institution:University of Chicago
A user reports:
I'm seeing performance issues with fees/fines in the Users app. Bringing up my own record, it took 8 seconds for the open fees page to move from showing a balance of zero with no fines, to listing the $1500+ in fines actually on the account. Is this a known performance issue?
In my testing, performance was quite bad for feesfines and loans. The log for mod-feesfines reports:
as well as
The log for mod-circulation-storage reports:
These requests happen multiple times when you access the user record and the user's fees/fines. The slow requests are:
Also quite slow:
There are obviously multiple issues here:
- The UI is making redundant requests of the backend, which should be cleaned up. The problem is exacerbated by the fact that the requests are very slow to respond when there is a large dataset of loan and fee/fine records.
- The backend modules are missing indexes that could help with performance.
I will raise separate issues for the backend.
This affects the current Honeysuckle release, v5.0.9. I note that this is listed as "unreleased" in JIRA.