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. You will, of course, eventually close the database file -- possibly immediately after a long importing session. This will collapse the WAL journal. Big journal files may make WAL mode unsuitable for small devices, of course, but on a desktop computer it shouldn't be a problem. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users