https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26633
Adolfo RodrÃguez Taboada <adolfo.rodrig...@xercode.es> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |adolfo.rodrig...@xercode.es
--- Comment #73 from Adolfo RodrÃguez Taboada <adolfo.rodrig...@xercode.es> ---
I am working with a client that has 447 branches and 25 itemtypes. Most
transfers between branches are not allowed, so there are almost 5 million
records in the branch_transfer_limits table, 199342 records by itemtype.
The advanced editor runs out of memory in Chrome, producing errors that range
from freezing the computer to crashing the tab or the browser. In Firefox, it
starts loading the page but it doesn't end loading. This is without selecting
the itemtype, so it's only building the default view to hide it.
In the simple editor, I made changes in their installation of Koha so that
instead of checking every combination with a SQL sentence (SELECT * FROM
branch_transfer_limits WHERE toBranch = ? AND fromBranch = ? AND $limitType =
?), it checks all the limits for the branch with only one SQL sentence (SELECT
* FROM branch_transfer_limits WHERE fromBranch = ?) and stores the result in a
hash. This way the simple editor works properly for big networks like this one.
I haven't found a way to apply a similar improvement in the performance of the
advanced editor.
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
