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