http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7872 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |chris@bigballofwax.co.nz --- Comment #10 from Chris Cormack <chris@bigballofwax.co.nz> --- (In reply to comment #6)
(In reply to comment #5)
LIMIT 1 is not needed since adding framework to WHERE always returns single row and it's more correct.
Why more correct ? I don't understand. For me, LIMIT 1 should be used if we want only a unique row. I think it can increase performance (I agree with you, it is negligible).
Actually a where on an indexed column is a lot faster than using limit, explain is a good tool for looking at the query plan to see how mysql is optimising the query. There is a whole project of sql optimisation we could do by checking some of our more used queries. -- You are receiving this mail because: You are watching all bug changes.