[Koha-bugs] [Bug 11305] Patrons with hundreds of checkouts cause extreme slowdown

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11305

--- Comment #1 from Kyle M Hall <kyle at bywatersolutions.com> ---
Created attachment 23157
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=23157&action=edit
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

-- 
You are receiving this mail because:
You are watching all bug changes.