[Koha-bugs] [Bug 20664] Optimize retrieval of biblio and item data

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

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

David Cook <dcook at prosentient.com.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dcook at prosentient.com.au

--- Comment #49 from David Cook <dcook at prosentient.com.au> ---
(In reply to Ere Maijala from comment #14)
> The latest patch is more simple and avoids any attempts at caching prepared
> statements. Fortunately MySQL prepares quickly, so the performance
> improvement is still good.

I was really excited when I read that you were going to use cached prepared
statements (as I've used them to gain huge performance boosts on other Perl
projects), so I'm saddened to see this, but after reviewing GetMarcItemFields I
see that it would be challenging/impossible to do well, because of the dynamic
query generation with @itemnumbers. Was that the reason you didn't do it?

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