[Koha-bugs] [Bug 23966] Branch Transfer Limits editor unusable for sites with many libraries and ccodes/itemtypes

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

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

--- Comment #1 from Kyle M Hall <kyle at bywatersolutions.com> ---
Created attachment 95024
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=95024&action=edit
Bug 23966 - Branch Transfer Limits editor unusable for sites with many
libraries and ccodes/itemtypes

Right now the branch transfer limits editor works fine if an instance has a
small number of libraries
and ccodes/itemtypes, but for large consortia who may have over 100 branches
and ccodes/itemtypes,
the editor page can take literal minutes to load ( we have partners where the
page load time is 7-8 minutes ).

This is because we run a separate database query for each limit. We should use
a single query to find all the limits for this page.

Test Plan:
1) Enable BranchTransferLimits
2) Create some limits, test adding and removing limits
3) Apply this patch
4) Restart all the things!
5) Reload the page, you should see the same limits in place as before
6) Test adding and removing limits, everything should behave the same
   as it did before the patch was applied!

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