The switch to storing data in SQLite databases has caused a problem for Firefox users who use the web browser heavily. The databases grow over time and reduce the startup time and responsiveness of the web browser due to fragmentation. This can be largely attributed to the fact that Firefox will not optimize the databases [...]
Optimize Firefox Databases With Vacuum Places
The Mozilla Firefox development team switched to SQlite databases for data storage in Firefox 3. One problem that arose because of this switch was an increasing Firefox profile folder size as there was no build in way to optimize the SQlite databases regularly. We reviewed a solution to this problem a while ago (read: optimize [...]
Create Firefox Smart Bookmarks
Firefox 3 changed the bookmarking system from using html files to using sqlite databases. One benefit of using databases is the possibility to run custom queries. Three of the so called smart bookmarks are already available after installing Firefox3: Most Visited, Recently Bookmarked and Recent Tags all make use of database queries to provide the [...]
