On 2 Oct 2016, at 9:35pm, Domingo Alvarez Duarte <[email protected]> wrote:
> I'm still fighting to use sqlite with a 20GB database and now I'm trying to
> update a table with 980M rows but sqlite is eating all my memory (2GB) and
> making blocking my computer (too much swap).
I assume you are not using any unusual PRAGMAs and are not using
multiprocessing while your update executes. Please execute this command on the
database (you can use the shell tool).
PRAGMA journal_mode
If the result is WAL then execute
PRAGMA journal_mode = TRUNCATE
otherwise execute
PRAGMA journal_mode = WAL
Then try your operation again.
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
