On 19 Aug 2014, at 8:25am, Paul Dillon <paul.dil...@gmail.com> wrote:
> I was > using count(first_field) instead of selecting all the fields, can't imagine > that could be the problem. There's an optimization in SQLite which means you can do COUNT(*) and it will fetch no data at all. It's faster than doing any COUNT(specific_field). Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users