Simon Slavin-3 wrote
>> - WAL log size 7.490 GB
> 
> Please repeat your tests but as the first command after opening your
> database file issue
> 
> PRAGMA journal_size_limit = 1000000
> 
> With this change the WAL file may still grow to 7 GB while that particular
> transaction is being executed but should be reduced in size after the
> transaction is completed.

Thanks for the tip. I'll do so.




--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Huge-WAL-log-tp79991p80018.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to