https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19884
--- Comment #16 from David Gustafsson <glask...@gmail.com> --- 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. -- 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/
