[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