Hello Richard, When does the WAL get trimmed down? If my transaction completes, does the WAL file get deleted? I've seen the WAL grow to 4 times my actual DB size so, I don't really want 160 Gigs of WAL hanging out when the process that generated it is only run once a month.
Wednesday, November 30, 2011, 10:02:34 AM, you wrote: RH> On Wed, Nov 30, 2011 at 4:41 AM, Sreekumar TP <sreekumar...@gmail.com>wrote: RH> Because we have experimentally determined that it is faster to overwrite an RH> existing file than to append to a file. So we don't truncate the WAL file RH> on a checkpoint, which makes subsequent writes to the WAL file go faster. RH> SQLite will truncate the WAL file down to the size specified by the "PRAGMA RH> journal_size_limit" setting, if you have set the journal_size_limit. >> >> -Sreekumar >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
