Re: [sqlite] expected performance of selecting large numbers of records

2015-01-31 Thread Godmar Back
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

[sqlite] expected performance of selecting large numbers of records

2015-01-30 Thread Godmar Back
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,