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 have a single SQLite 2-column table with a primary TEXT key and a value,
like so (id TEXT PRIMARY KEY, value TEXT). One process adds new records
periodically, perhaps 1-10 per minute. The database currently has 850,000
entries and is 7.3GB large on disk.
I also need to perform bulk queries,
Mail list logo