Confirmed users
595
edits
Firefox/Projects/Places Vacuum: Difference between revisions
m
→Better vacuum support in SQLite
| Line 60: | Line 60: | ||
=== Better vacuum support in SQLite === | === Better vacuum support in SQLite === | ||
Short term we | Short term we need at least a way to tell if a database needs to be defragmented, 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): | 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. | * external applications can add binary annotations and we can't guess what's the size of those. | ||