https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20664 --- Comment #56 from David Cook <dcook@prosentient.com.au> --- (In reply to Ere Maijala from comment #55)
This should provide a nice performance improvement also for exports for indexing.
Excellent.
MySQL is quick to prepare statements, that's why we can get away with it. Other databases may have different behavior, and there are certainly slower ones in that regard.
MySQL also makes some really bad query plans. Maybe that's how it achieves its speed. For Koha's user-generated SQL Reports I've actually resorted to using "index hints" lately to get efficient query plans. It's a MySQLism but can make a world of difference as well. In any case, I think any improvement is a well worthwhile improvement :D. So thanks for doing this one! -- You are receiving this mail because: You are watching all bug changes.