This tip will hopefully speed up your Firefox 3 by optimizing it’s database.
Firefox stores your browsing data using SQLite – self contained, small footprint database.
Having database store your browsing data has one drawback, you have to optimize the database from time to time to get rid of old, deleted data, re-index the columns etc.
Otherwise you keep all the junk data mixed in with your real data.
In SQLite is the statement to do this called VACUUM. So here’s how to vacuum your Firefox:
1. Download sqlite command line client for your platform. In Ubuntu, go to yout terminal and issue the following command:
1 |
sudo aptitude install sqlite3 |
2. Turn off your Firefox
3. Go to your profile folder
4. Issue the command:
* For Linux
1 |
for i in *.sqlite; do echo "VACUUM;" | sqlite3 $i ; done |
* For Windows
1 |
for %i in (*.sqlite) do @echo VACUUM; | sqlite3 %i |
Enjoy!