Thank you very much for those suggestions!

Select max(rowid) completes immediately, I haven't tried WAL mode and the
idea of sorting yet. appears to be down right now, but is up.

On Sat, Jan 31, 2015 at 5:31 AM, Igor Tandetnik <> 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

Reply via email to