Hello Richard, *The prgama PRAGMA journal_size_limit = **N , *does not seem to limit the size of the WAL log file. Is there any precondition to be satisfied before calling the pragma ?
-Sreekumar On Wed, Nov 30, 2011 at 7:04 PM, Teg <[email protected]> wrote: > 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 <[email protected] > >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 > >> [email protected] > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > > > > > > -- > Best regards, > Teg mailto:[email protected] > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
