[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

--- Comment #50 from Ere Maijala <ere.maijala at helsinki.fi> ---
> 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?

Unfortunately cached prepared statements don't work well with Plack where the
process can outlive the MySQL connection. We found that reconnection to MySQL
would leave the prepared statements holding on to the previous connection
leading to "MySQL server has gone away" errors. All this could be overcome with
additional logic, but that'd be another effort.

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