https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20664 --- Comment #50 from Ere Maijala <ere.maijala@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.