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 smaller chunks.
My question is, can I fix this DB? "integrity_check" says it's OK but, when I "Pragma wal_checkpoint;" from Sqlite.exe, nothing seems to happen. It completes and the WAL file is still 51 GB. I was expecting it to integrate the changes in the WAL file back into the DB file proper. -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users