Simon Slavin <slavins-drl2ohjjk6tg9huczpv...@public.gmane.org> writes: > On 6 Apr 2011, at 5:06pm, Nikolaus Rath wrote: > >> Another question though: what is the recommended way to insert lots >> of data with WAL enabled? Without a transaction, the WAL file stays >> small but the insertions take very long time. With a transaction, >> things are faster but the WAL file grows extremely big. > > The recommended way is not to care about the size of the journal file. > Do it in a transaction and make sure you have some free disk space.
From http://www.sqlite.org/wal.html: ,---- | WAL works best with smaller transactions. WAL does not work well for | very large transactions. For transactions larger than about 100 | megabytes, traditional rollback journal modes will likely be faster. For | transactions in excess of a gigabyte, WAL mode may fail with an I/O or | disk-full error. It is recommended that one of the rollback journal | modes be used for transactions larger than a few dozen megabytes. `---- That sounds as if large transactions are not recommended with wall. Is that page no longer up-to-date? Best, -Nikolaus -- »Time flies like an arrow, fruit flies like a Banana.« PGP fingerprint: 5B93 61F8 4EA2 E279 ABF6 02CF A9AD B7F8 AE4E 425C _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
