https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42765
--- Comment #1 from Kyle M Hall (khall) <[email protected]> --- Created attachment 202830 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=202830&action=edit Bug 42765: Add pagination to the checkouts table 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. Test Plan: 1) Create or find a patron with many checkouts from the past and from today 2) View the checkouts table from circulation.pl and/or moremember.pl 3) Apply this patch 4) Restart all the things! 5) Reload the page 6) Note the checkouts are now paginated! -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected] website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
