On 28.03.2011 13:32, Stefan Sperling wrote: > On Sat, Mar 26, 2011 at 09:46:48AM -0400, Greg Stein wrote: >> If it only needs to detect a single row, then LIMIT 1 should be in the >> query. > Is there really a significant difference between LIMIT 1 and not stepping > through more than one result row?
I'd expect there to be a difference in the amount of memory used and duration of the sqlite transaction. > I'd rather keep the queries reusable for contexts where a complete > list of modified nodes is required, instead of adding COUNT() (as > suggested elsewhere) or LIMIT 1. Well ... one can't actually parametrize the statements like this (you can parametrize the limit, but not the existence of a limit clause). I like reusable statements too, but on the other hand, I believe in doing as much as possible within the query engine. It always makes a difference, if nowhere else, then in the complexity of the processing code. -- Brane
