Hi Richard, How does sqlite determine the right size for the WAL file? Application can ofcourse indicate the maximum size.
-Sreekumar On Wed, Nov 30, 2011 at 4:02 PM, Richard Hipp <d...@sqlite.org> wrote: > On Wed, Nov 30, 2011 at 4:41 AM, Sreekumar TP <sreekumar...@gmail.com > >wrote: > > > Hello, > > > > I have sqlite configure to do manual checkpoint. I do checkpoint every > few > > hundred records. I expect the WAL to reduce in size and become zero when > > there are no more inserts done. > > However, I see that the WAL file size is static and does not reduce in > > size. Why isnt manual checkpoint reducing the size of WAL file. > > > > Because we have experimentally determined that it is faster to overwrite an > existing file than to append to a file. So we don't truncate the WAL file > on a checkpoint, which makes subsequent writes to the WAL file go faster. > > SQLite will truncate the WAL file down to the size specified by the "PRAGMA > 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 > > > > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users