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

2015-01-31 Thread Richard Hipp
On 1/31/15, Godmar Back wrote: > 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

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

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

2015-01-31 Thread Igor Tandetnik
On 1/31/2015 12:21 AM, Godmar Back wrote: If I want to do a dump of the table, as in "SELECT value FROM " I'll quickly get "database is locked" errors. Googling revealed that those are because a long running select keeps a cursor, and thus readlock on the entire database. I have since