https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19884
--- Comment #17 from Tomás Cohen Arazi <[email protected]> --- (In reply to David Gustafsson from comment #16) > Just to clarify, the performance gain comes from using DBI directly. > DBIx::Abstract could potentially be faster then > DBIx::Class::ResultSet::search, but in my opinion not much is gained by the > abstraction for such a simple at static query. > > If you are saying that the speed gain mainly comes from loading multiple > items at once and not the low-level SQL, that is actually not the case as > demonstrated by the previous benchmark. > > Loading multiple items with search (10 at the time) takes 50 seconds. > > Loading multiple items (10 at the time) with pure-SQL 7.4 seconds. > > And as previously noted, 10 items is pretty rare, so in practice the code > using search will produce an even worse result. Can you profile it using ntyprof? I bet the bottleneck comes from effective_itemtype when unblessing. -- 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/
