Compacting always seems to increase the database size. From less than a MB to over a MB. Just now, from 7MB to over 10MB. Why is this?
Because the SQLite engine is writing a “Write Ahead Log” file when it compacts. So that’s what increases the size. But if you quit and launch again, it goes back down to normal.
But also, the compact operation purges deleted records and unreferenced attachments. So if you never deleted any records, then the size won’t probably be reduced much. But if you’ve delete a bunch of records, then you’ll see the compact function make a difference.
Thanks for the explanation!
.
