https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20664
--- Comment #50 from Ere Maijala <[email protected]> --- > 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
