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

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #1 from Nick Clemens <nick at bywatersolutions.com> ---
Tested with Tomas this morning, a few notes:

using the correct relationships for prefetch: item,patron
that reduces DB calls, otherwise we are still doing a hit every time we use
related object
that still doesn't increase performance

Using DBIC directly to avoid Koha objects does not change things, we still see
much great performance without prefetch

Using SQL directly is faster, as expected, fetching 500 rows it was about ~1.5
seconds vs ~3 seconds with Koha:Objects, no prefetch

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