Bug 11305

Summary: Patrons with hundreds of checkouts cause extreme slowdown
Product: Koha Reporter: Kyle M Hall <kyle>
Component: Architecture, internals, and plumbingAssignee: Kyle M Hall <kyle>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: jdemuth, katrin.fischer
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: Bug 11305 - Patrons with hundreds of checkouts cause extreme slowdown - Quick fix [v3.12.x]

Description Kyle M Hall 2013-11-26 12:33:20 UTC
For pages such as circulation.pl and moremember.pl, any patron with over a hundred checkouts or more can take an extremely long time to load ( 10's of seconds or more ). This is due to the large amount of data pulled and processed to display the patron's previous checkouts, relative's checkouts, and holds.
Comment 1 Kyle M Hall 2013-11-26 12:36:56 UTC
Created attachment 23157 [details] [review]
Bug 11305 - Patrons with hundreds of checkouts cause extreme slowdown - Quick fix [v3.12.x]

For pages such as circulation.pl and moremember.pl, any patron with over
a hundred checkouts or more can take an extremely long time to load (
10's of seconds or more ). This is due to the large amount of
data pulled and processed to display the patron's previous checkouts,
relative's checkouts, and holds.

To use:
1) Apply this patch
2) Create a "Local use" system preference "CirculationRowsLimit"
3) Set CirculationRowsLimit to an integer value. This value will
   be the maximum number of rows pulled for issues, relatives' issues
   and holds for circulation.pl. To view a patron's entire list of
   issues, use moremember.pl
Comment 2 Katrin Fischer 2014-11-10 23:40:09 UTC
Kyle, is this fixed with the ajax checkout table?
Comment 3 Kyle M Hall 2014-11-17 11:34:53 UTC

*** This bug has been marked as a duplicate of bug 11703 ***