[sqlite] howto shrink files in wal mode

[Dan Kennedy]

On 05/07/2015 04:46 PM, Zaumseil Ren? wrote:
>> How are you measuring the size of the database file ?
>>
>> Simon.
> Using the tcl "file" command.
>
> puts b=[file size $dbfile]
>
> Please see in the script in the original post.

If you do the VACUUM before the "PRAGMA wal_checkpoint" instead of 
after, does that help?

Dan.