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 (vote)
Assignee: Kyle M Hall
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-11-26 12:33 UTC by Kyle M Hall
Modified: 2014-11-17 11:34 UTC (History)
2 users (show)

See Also:
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] (10.99 KB, patch)
2013-11-26 12:36 UTC, Kyle M Hall
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 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 ***