[Koha-bugs] [Bug 30169] Prefetching is expensive for performance

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Feb 24 17:04:32 CET 2022


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30169

--- Comment #4 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
               Rate     kohaJoin     dbicJoin kohaPrefetch dbicPrefetch
kohaJoin     1.69/s           --          -4%         -79%         -81%
dbicJoin     1.76/s           4%           --         -78%         -80%
kohaPrefetch 8.09/s         378%         359%           --         -10%
dbicPrefetch 9.03/s         434%         413%          12%           --

Result from above.. shows dbicPrefetch is fastest (I didn't measure straight
SQL with and without a join).. and kohaPrefetch isn't as much slower than dbic
than I thought it might be.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.


More information about the Koha-bugs mailing list