Summary: | Patrons with hundreds of checkouts cause extreme slowdown | ||
---|---|---|---|
Product: | Koha | Reporter: | Kyle M Hall (khall) <kyle> |
Component: | Architecture, internals, and plumbing | Assignee: | Kyle M Hall (khall) <kyle> |
Status: | RESOLVED DUPLICATE | QA Contact: | Testopia <testopia> |
Severity: | normal | ||
Priority: | P5 - low | CC: | jdemuth |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
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] |
Description
Kyle M Hall (khall)
2013-11-26 12:33:20 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 Kyle, is this fixed with the ajax checkout table? |