On Wed, Nov 30, 2011 at 1:04 PM, Teg <t...@djii.com> wrote: > Hello Richard, > > When does the WAL get trimmed down? If my transaction completes, does > the WAL file get deleted? I've seen the WAL grow to 4 times my actual > DB size so, I don't really want 160 Gigs of WAL hanging out when the > process that generated it is only run once a month. >
SQLite starts writing the WAL file from the beginning again on the first write transaction that follows a checkpoint that ran to completion and where there are no readers using the WAL file. A checkpoint will normally run to completion if there are no readers still using prior transactions. If there are readers on prior transactions, then the checkpoint cannot run to completion since that would delete content out from under the readers. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users