e.g. If you do: SELECT c1 from t1 ORDER BY c2 LIMIT 5;
vs. just running the query without the "LIMIT" clause and taking the top 5 rows programmatically? Obviously in the case of a subquery this makes a difference: select count(*) from (select * from t1 limit 5); But would it ever in a straight query with joins etc.? - Deon _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users