Confirm
595
edits
Changes
m
→Better vacuum support in SQLite
=== Better vacuum support in SQLite ===
Short term we would need at least need a way to tell if a database needs to be fragmenteddefragmented, this is actually not possible without manually parsing the database file page by page. That would be over-engineering, slow, and hard to maintain (if the file format changes).
Using Places Stats to get a "magic number" able to tell us if the database size is exagerated is not possible. We can get a guess, but in many cases it will generate false positives due to a couple things (i tried generating some spreadsheet to test the thing):
* external applications can add binary annotations and we can't guess what's the size of those.
