Re: [sqlite] Effect of VACUUM when very low on disk space

2009-12-07 Thread Simon Slavin
On 7 Dec 2009, at 2:27pm, Nick Shaw wrote: > When the file exceeds a certain size, I DELETE a specific number of > records, then VACUUM the file to get the size back below required > limits. This works fine, however what happens to the VACUUM command if > there is insufficient disk space for

[sqlite] Effect of VACUUM when very low on disk space

2009-12-07 Thread Nick Shaw
Hi all, I'm currently writing some code that attempts to keep an SqLite database file below a certain file size (the embedded PC it is running on has a wonderful side effect that when the disk runs out of disk space, it blue-screens Windows and you can't boot the device after that - how