On 7 May 2015, at 11:25am, Zaumseil Ren? <RZaumseil at kkg.ch> wrote:
> But my problem remains :( If I do the script step by step I also do not see > the file shrink in the file explorer. > The dbfile will only shrink "after" I close the db connection. Even with an > explicit "vacuum" command. > > So the question remain: How to shrink an used dbfile in wal mode? I think the file actually has shrunk. I just think that the size reported is not updated while the file is open. This is definitely true in File Explorer and may be true for tcl too. This is a choice made by your operating system and nothing can be done inside SQLite to override it. Simon.