On Sat, Apr 1, 2017 at 10:04 AM, J Decker <d3c...@gmail.com> wrote: > > > On Sat, Apr 1, 2017 at 9:59 AM, Richard Hipp <d...@sqlite.org> wrote: > >> On 4/1/17, J Decker <d3c...@gmail.com> 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 >> d...@sqlite.org >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
