On 8 Aug 2017, at 6:30pm, Jens Alfke <j...@mooseyard.com> wrote:
> We’ve also seen that, on low-end hardware like mobile devices, I/O bandwidth
> is limited enough that a running compaction can really harm the
> responsiveness of the _entire OS_, as well as cause significant battery drain.
Yes. Cannot stress enough that you don’t need VACUUM for efficient storage.
It locks the entire database, it monopolises access to storage, and it does
many writes to storage which means it’ll wear through Flash storage cycles.
What used to be the great advantage of VACUUM — defragmentation — was useful
for hard disks but does not give any advantage for Flash storage.
The only advantages are to save filespace immediately after deleting data or
indexes. You might want VACUUM if you delete data, then take a copy of your
database for backup. But most SQLite databases are small enough that this
sqlite-users mailing list