Hello,
At what point does an SQLite database vacuum?
When a vacuum occurs, do all the SQLite databases on the device vacuum at the same time?
Is there a reoccurring time where it might vacuum without reason? Like every 4 weeks?
Thanks
This implies an auto vacuum will only occur if the app creator has added it individually to a particular app?
This implies an auto vacuum will only occur if the app creator has added it individually to a particular app?
Correct - it is disabled by default and only activated if the software using it enables it.
thank you for your replies.
Does anyone happen to know if Photos, iMessage, WhatsApp and Facebook Messenger “auto vacuum” on iOS?
You can tell by looking at the header of the database:
https://www.sqlite.org/fileformat.html
Offset 52 Length 4 bytes
The page number of the largest root b-tree page when in auto-vacuum or incremental-vacuum modes, or zero otherwise.
