https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19884
--- Comment #14 from David Gustafsson <[email protected]> --- Hi! I'm not sure I understand, but where you thinking of skipping the pure-SQL optimization but keeping the one loading multiple items at once using search instead of find and then unblessing? Unfortunately that does not make that much of a difference it seems. I tried benchmarking with a biblio with 10 items (which is pretty rare, think most of our biblios has only 1 or 2 items): Loading each item separately took 372 seconds. Loading multiple (10) items at once took 47 seconds: This is not bad (about 8 times faster, for 10 items, which is to be expected since results in 1/10 of DBIx calls). Unfortunately since most libraries probably only have a couple of items per biblio, averaging below 2, in practice the speedup is probably below 2 times faster. With the pure SQL variant loading multiple items it took 7.4 seconds. All benchmarks where performed with item-level_types = 1, and loaded the items 20000 times. I tried to make sure serials where not affected by adjusting the code for the fethching of multiple items, and all tests passes (not sure if there are tests for serials), but I could have another look at this. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://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/
