On 11 Dec 2014, at 3:58pm, Paul Sanderson <sandersonforens...@gmail.com> wrote:
> would count _rowid_ from mytable be quicker Hmm. Given that these tables have the normal use of rowid, and that rows in this table are only inserted, never deleted, I wonder whether SELECT max(rowid) FROM myTable would have given the right result, almost instantly. Can't check it now, but thanks for the idea, Paul. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users