[Koha-bugs] [Bug 26963] Koha::Template::Plugin::Branches::pickup_locations is very inefficient, causing timeouts on records with large numbers of holds/items

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26963

Kyle M Hall <kyle at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #113282|0                           |1
        is obsolete|                            |

--- Comment #2 from Kyle M Hall <kyle at bywatersolutions.com> ---
Created attachment 113283
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=113283&action=edit
Bug 26963: Koha::Template::Plugin::Branches::pickup_locations is very
inefficient, causing timeouts on records with large numbers of holds/items

If a record has a large number of holds ( > 50 I'd say ), and a large number of
items, checking the pickup locations takes so long the script often times out.
We need to find a way to cache the results so we don't have to spend so much
time on expensive lookups.

Test Plan:
1) Create a record with 100 items
2) Create 100 holds that are item level
3) You should start to see slow page loads as you create more holds
4) Apply this patch
5) Restart all the things!
6) Note the hold page now loads faster
7) Subsequent loads should be even faster due to the caching mechanism

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