Actually, shrinking and growing the file size can cause both file fragmentation and internal database fragmentation. If there is always available space in the file, it will reduce the potential table fragmentation when adding new records.
This is also why constantly VACUUMing the database is actually not a good thing. Having empty space in the file, especially when it's spread amongst the different data structures, allows those data structures to be updated and grow in a more contiguous manor. An occasional VACUUM is a good thing, and Firefox should already be doing this automatically. But doing it too often gives you diminishing returns and can be unhealthy for the database.
Why are .sqlite files so much larger in Firefox 4 ?
- Bluefang
- Posts: 7857
- Joined: August 10th, 2005, 2:55 pm
- Location: Vermont
- Contact:
Re: Why are .sqlite files so much larger in Firefox 4 ?
There have always been ghosts in the machine... random segments of code that have grouped together to form unexpected protocols. Unanticipated, these free radicals engender questions of free will, creativity, and even the nature of what we might call the soul...