The Mozilla Firefox development team has changed the way the web browser is storing information to SQLite databases in Firefox 3. Cookies, Bookmarks, RSS feeds and many other information are now stored in SQLite databases that are stored in the Firefox profile. A problem that can arise is that the databases can get fragmented over time which inflates their size and has the consequence that the performance drops especially in the time the web browser is loading but also when information are pulled from the databases.
It is possible to optimized SQLite databases which defragments them so that their size decreases and performance is gained. The website Web Upd8 explains how to optimize the SQLite databases of Firefox running under Windows, Linux or Mac OS. Windows users for example need to download a batch file and place them into the Firefox profile that they want to optimize.
The batch file will run the vacuum command on all SQlite databases that are located in the profile folder. The effect of the optimization depends largely on the fragmentation of the SQLite databases. Optimization on a test system reduced the size of the Firefox profile folder from 64.8 Megabytes to 53.4 Megabytes. Users with many bookmarks and RSS feeds will most likely see a large size reduction of the profile folder while users who use Firefox only occasionally will see little to no improvement.
Enjoyed the article?: Then sign-up for our free newsletter or RSS feed to kick off your day with the latest technology news and tips, or share the article with your friends and contacts on Facebook or Twitter.Related Articles:
Optimize Firefox Databases With Vacuum PlacesSpeedyFox Optimizes Firefox Databases To Speed Up The Web Browser
Vacuum Places Improved Firefox Database Optimization
Fix: Cannot Delete Firefox 3 Bookmarks
Firefox Profile Data Storage: How to Hack it
Is there any way to limit the size of this databases?
Thanks in advance!
There is no automatic way to limit the size. You have to do it manually.
Really great find Martin this works, ferry well.
wow nice info. .thx