On 14 Dec 2014, at 11:08am, Jean-Christophe Deschamps <j...@antichoc.net> wrote:
> Without using slow triggers or changing the v3 file format there is still > another possibility which could be implemented relatively easily. All it > would need is a new pragma (or internal function) like "pragma row_count=0/1" > and some code. > > On invokation, the engine would create a hidden "system" table like > sqlite_rowcount --similar to sqlite_sequence-- which would initially hold row > counts for every table in the DB. Two obvious places: A) In that sqlite_sequence table you mentioned, as an additional column. Always up-to-date. B) In the tables prepared by SQLite ANALYZE. If you want the rowcount updated, do another ANALYZE. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users