On 8 Oct 2011, at 2:27am, Roger Binns wrote: > Although various people keep mentioning it I haven't seen you acknowledge > using EXPLAIN QUERY PLAN. It would be nice to hear if it turns out to be > helpful especially as it doesn't require mucking with the query itself.
Yes it was a good suggestion to my original problem, but now I know LIMIT works properly I don't think I need it. I'll just use LIMIT 51 on my query and if I get 51 results back I'll know there are too many for the query to be useful. My original query was posted because I thought SQLite always processed all rows even if you used LIMIT. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
