> 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 <[email protected]> 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 <[email protected]> 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 > [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
