[Bug 11305] New: Patrons with hundreds of checkouts cause extreme slowdown
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11305 Bug ID: 11305 Summary: Patrons with hundreds of checkouts cause extreme slowdown Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt@gmail.com Reporter: kyle@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org 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. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11305 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|gmcharlt@gmail.com |kyle@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11305 --- Comment #1 from Kyle M Hall <kyle@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.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11305 jdemuth@roseville.ca.us <jdemuth@roseville.ca.us> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jdemuth@roseville.ca.us -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11305 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Kyle, is this fixed with the ajax checkout table? -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11305 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |DUPLICATE --- Comment #3 from Kyle M Hall <kyle@bywatersolutions.com> --- *** This bug has been marked as a duplicate of bug 11703 *** -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org