If you go to your Firefox profile folder, you should see a bunch of files ending with .sqlite extension. There are a total of 10 sqlite databases which is content-prefs.sqlite, cookies.sqlite, downloads.sqlite, formhistory.sqlite, places.sqlite, permissions.sqlite, search.sqlite, signons.sqlite, urlclassifier3.sqlite and webappsstore.sqlite. Searching the Internet reveals a lot of guides and even Firefox addons that can automatically â€œvacuumâ€ or optimize Firefox database but most of them only does it on the places.sqlite database file which is the main culprit for a crawling slow Firefox.
It works but wouldnâ€™t it be better if we can optimize ALL of the Firefox databases? Thanks to SpeedyFox we can now do that.

SpeedyFox is a brand new small utility that fixes this problem with a single click! It seems unbelievable but after you optimize your Firefox with this tool, you will get a fresh newly-installed feel because the speed indeed gets considerably faster. You will get up 3 times faster startup speed, browsing history will become faster, and performing operations with cookies will be quicker than before.

Once installed, SpeedyFox automatically detects your Firefoxâ€™s default profile. If you have more than one profile, you can select the one you want to optimize from the drop-down menu. All you have to do is select the default profile that you want to optimize and hit Speed Up Firefox button. The optimization process can take anywhere from 5 minutes to an hour depending on how large your databases are. The whole optimization process is safe as it does not effect your history, bookmarks, passwords, etc.