Bug 11305 - Patrons with hundreds of checkouts cause extreme slowdown
Summary: Patrons with hundreds of checkouts cause extreme slowdown
Status: RESOLVED DUPLICATE of bug 11703
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal
Assignee: Kyle M Hall (khall)
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-11-26 12:33 UTC by Kyle M Hall (khall)
Modified: 2014-11-17 11:34 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments
Bug 11305 - Patrons with hundreds of checkouts cause extreme slowdown - Quick fix [v3.12.x] (10.99 KB, patch)
2013-11-26 12:36 UTC, Kyle M Hall (khall)
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Kyle M Hall (khall) 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 (khall) 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 (khall) 2014-11-17 11:34:53 UTC

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