[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 #51 from David Cook <dcook at prosentient.com.au> ---
(In reply to Ere Maijala from comment #50)
> 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.

That's an interesting point, although I was thinking of just caching (actually,
re-using is probably a more accurate word than caching here) the prepared
statement in the scope of the batch operation. I wouldn't cache it at the level
of the Plack web server.

I actually had to deal with that reconnection issue on a separate project
recently (see "validate-on-match" and "background-validation" at
https://docs.jboss.org/jbossas/docs/Server_Configuration_Guide/beta500/html/ch13s13.html).

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