On Thu, Feb 10, 2011 at 6:04 PM, Richard Hipp <d...@sqlite.org> wrote: > There needs to be a time when there are no read or write transactions using > the WAL so that it can reset, and you need to run PRAGMA wal_checkpoint > during that time. Otherwise the WAL will grow without bound. > > See also the RESET option on PRAGMA wal_checkpoint that will appear in > version 3.7.6: > > http://www.sqlite.org/draft/pragma.html#pragma_wal_checkpoint > http://www.sqlite.org/draft/c3ref/wal_checkpoint_v2.html
Should I expect this to work in the current trunk? When I do a "PRAGMA wal_checkpoint(RESET)", it returns (1, -1, -1) and the wal files just stick around. --Mike Barton _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
