https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26633
Adolfo RodrÃguez Taboada <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #73 from Adolfo RodrÃguez Taboada <[email protected]> --- 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 [email protected] 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/
