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.
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
Kyle, is this fixed with the ajax checkout table?
*** This bug has been marked as a duplicate of bug 11703 ***