> We're issuing "PRAGMA > wal_checkpoint" to the open DB handle.
If you want guaranteed finish of the checkpoint (and thus not growing WAL-file) you need to issue "PRAGMA wal_checkpoint(RESTART)". Pavel On Tue, Jun 7, 2011 at 10:36 PM, Eric Sigler <esig...@expensify.com> wrote: > So, should the WAL file shrink back to 0 then? We're issuing "PRAGMA > wal_checkpoint" to the open DB handle. > > -Eric > > On Tue, Jun 7, 2011 at 7:06 PM, Pavel Ivanov <paiva...@gmail.com> wrote: >>> (Actually, that was another general question we had, should that WAL >>> file ever shrink during use? Why would it grow to that size at all?) >> >> It shrinks, when the full checkpoint is completed successfully. Until >> then it grows. >> >> >> Pavel > _______________________________________________ > 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
