On 19 May 2009, at 4:26pm, Sam Carleton wrote: > Marco Bambini wrote: >> SELECT ... LIMIT 1; >> > Marco, Is this to say that adding the LIMIT 1 does make it more > efficient?
LIMIT does not make the query (much) more efficient: the software still needs to do the same filtering and sorting, it just returns a shorter table. However, LIMIT does reduce the amount of memory (or possibly disk space) that the result table takes up, until you dispose of it, since the results are limited to one row. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
