https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18861
--- Comment #9 from Fridolin Somers <fridolin.som...@biblibre.com> --- (In reply to Nick Clemens from comment #8) > I updated the patch, but in testing I didn't see any difference. > > I added many types and branches: > INSERT INTO itemtypes (itemtype,description) SELECT > CONCAT(itemtype,"A"),CONCAT(description,"A") FROM itemtypes; > INSERT INTO itemtypes (itemtype,description) SELECT > CONCAT(itemtype,"B"),CONCAT(description,"B") FROM itemtypes; > INSERT INTO itemtypes (itemtype,description) SELECT > CONCAT(itemtype,"C"),CONCAT(description,"C") FROM itemtypes; > INSERT INTO itemtypes (itemtype,description) SELECT > CONCAT(itemtype,"D"),CONCAT(description,"D") FROM itemtypes; > INSERT INTO branches (branchcode,branchname,pickup_location) SELECT > CONCAT(branchcode,"A"),CONCAT(branchname,"A"),pickup_location FROM branches; > INSERT INTO branches (branchcode,branchname,pickup_location) SELECT > CONCAT(branchcode,"B"),CONCAT(branchname,"B"),pickup_location FROM branches; > INSERT INTO branches (branchcode,branchname,pickup_location) SELECT > CONCAT(branchcode,"C"),CONCAT(branchname,"C"),pickup_location FROM branches; > INSERT INTO branches (branchcode,branchname,pickup_location) SELECT > CONCAT(branchcode,"D"),CONCAT(branchname,"D"),pickup_location FROM branches; > > Before and after the indexes it took about 30 seconds for the page to load How many entries do you have in table branch_transfer_limits ? -- 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/