[sqlite] 5 GB DB with a 51 GB wal file.

I have a 5GB DB file, 5 simple tables. Several million entries. When I tried to delete perhaps 10% of the entries. The WAL file blew up to 51 GB, 10 times bigger than the DB file itself. I understand the problem I think, with long transactions and have since split the transactions up into smalle

Re: [sqlite] 5 GB DB with a 51 GB wal file.

Hello Teg, Thursday, November 11, 2010, 12:08:23 PM, you wrote: T> I have a 5GB DB file, 5 simple tables. Several million entries. When I T> tried to delete perhaps 10% of the entries. The WAL file blew up to T> 51 GB, 10 times bigger than the DB file itself. I understand the T> problem I think