https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19884
--- Comment #32 from David Gustafsson <glask...@gmail.com> --- I made variants of GetMarcBiblio and EmbedItemsInMarcBiblio (GetMarcBiblios and EmbedItemsInMarcBiblio) that accepts multiple biblionumbers instead of just one. This way all items can be loaded at once for all of these biblios, avoiding the overhead of callings search/find once for each item. Running this script (https://gist.github.com/gnucifer/1e33f9aa7155b1b771baaa357dfc7141) it seems to give about the same performance boost as the SQL-hack. When using this strategy just benchmarking GetItems is not feasible since the speedup is because GetItems now need to run a fraction of the times (about 1/2000 for a batch size of 2000) as before, making the impact of DBIx-search having a large overhead preparing the query compared to the low lever interface not matter that much. I will try to produce a before/after NYTProf-flamegraph with the latest benchmarking script (it's a little bit messy since does not have the production data available in my dev-box, and need to produce the results in our staging environment). -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/