Thank you very much for those suggestions! Select max(rowid) completes immediately, I haven't tried WAL mode and the idea of sorting yet.
https://www.sqlite.org/wal.html appears to be down right now, but http://www.sqlite.org/wal.html is up. On Sat, Jan 31, 2015 at 5:31 AM, Igor Tandetnik <i...@tandetnik.org> wrote: > > I'm not sure what you mean by "dump an approximate snapshot". I meant that I don't care whether records that were recently added, say during the last few seconds, are included in the total count()/dump of all records or not. So I'm fine with an approximate snapshot that may not have a few of the latest updates. - Godmar _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users