https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42765 Bug ID: 42765 Summary: Add pagination to the checkouts table Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs@lists.koha-community.org Reporter: kyle@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle@bywatersolutions.com The checkouts table on circulation.pl and moremember.pl works fine for most patrons, but causes issues for patrons with hundreds of checkouts, especially if the table is set to load automatically. In practice, we've seen a patron with 200ish checkouts take about 10 seconds to load the table. If the patron is then checking out another stack of items ( let's say 20 ) it's possible to lock up the entire server. This happens because those svc/checkouts continue to stack up and use up workers. A fast enough librarian will be able to get to the point where most if not all workers are calling svc/checkouts. If it takes 10 seconds to resolve the api call, and 3 seconds to check out an item, the process will plateau at 4 workers being dedicated to just calling svc/checkouts for just that patron. Setting LoadCheckoutsTableDelay to a non-zero value works around the symptom, since the next scan's page reload cancels the pending request before it fires, but the real fix is to make the table server-side so it only fetches the recent subset of checkouts by default. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.