On Sat, Apr 1, 2017 at 10:04 AM, J Decker <[email protected]> wrote: > > > On Sat, Apr 1, 2017 at 9:59 AM, Richard Hipp <[email protected]> wrote: > >> On 4/1/17, J Decker <[email protected]> wrote: >> > >> > So really - after frames are recovered, can't they be cleared? >> >> Is see. You want a "checkpoint". That will happen automatically when >> the size of the WAL file reaches 1000 frames. But you can force it to >> happen sooner by running "PRAGMA wal_checkpoint". >> >> > the other wall is up to 6000 frames (I think I had an error in the script > for a bit and the process kept restarting very very quickly but... it was > probably just 2 frames per time to get to 6000 ) >
I added a wal_checkpoint as part of connection, so now the wal stays at 2 frames... recovered into WAL state I guess? not actually recovered... it was commited. > > >> -- >> D. Richard Hipp >> [email protected] >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
