Incremental auto-vacuum


#1

Does anybody has experience with vacuum strategies? Since full VACUUM could introduce some potentially risky situation, we decided to use auto-vacuum which we would trigger from application. Does call frequency to this has any drawbacks in the respect of sqlcipher?
Thanks.


#2

Hello @aleksandarkostic we don’t have any specific recommendations regarding vacuum with SQLCipher. It sounds like you will be using incremental auto-vacuum, since you refer to triggering it from the application. The standard caveats apply, e.g. that auto-vacuum can result in greater fragmentation, pages aren’t compacted, freelist pages are moved to the end of the database, etc. It’s worth noting that that SQLCipher forces the database secure_delete option, so that either way, deleted data is zeroed out.