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 is up.
>
There wa
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 wrote
On Sat, 31 Jan 2015 00:21:18 -0500, Godmar Back wrote:
>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.
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 rewritt
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, whic
5 matches
Mail list logo