[Koha-bugs] [Bug 23966] Library 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

Bouzid Fergani <bouzid.fergani at inlibro.com> changed:

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

--- Comment #3 from Bouzid Fergani <bouzid.fergani at inlibro.com> ---
Created attachment 99442
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=99442&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!

Signed-off-by: Bouzid Fergani <bouzid.fergani at inlibro.com>

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