Last year I examined ways to optimize Firefox’s SQLite databases. I’ve since found I like it better when I just put the Firefox profile in a ramdisk, but that may not be an option in all cases.
If you don’t want to go the latter route and would like to avoid the command line jockeying, give Speedyfox a look. And even if you’ve put Firefox in a ramdisk, this program can be useful. You won’t notice any speedup inside a ramdisk, but SQL optimization saves storage space, which is always at a premium inside ramdisks.
Speedyfox is a simple Windows and Mac OS X application that looks for Firefox, Thunderbird, Chrome, and Skype, and offers to optimize their profiles. I used it this past weekend on a computer that wasn’t a candidate for my ramdisk treatment, and found it worked well.
It doesn’t just vacuum the Places database, but it cleans up all of them. Just close all of the relevant programs, run Speedyfox, check any program you want to optimize, then click a button. It doesn’t get much simpler.
The program claims to speed up start times. Its effectiveness on startup times will vary, but I’m more concerned about the speed of the program when it’s running. After a few months, Firefox really starts to drag and its CPU and memory usage get even more unreasonable. Regular database maintenance goes a long way toward preventing this browser rot.
It works well, it’s easy to use, and it’s free. What’s not to like about all that?

David Farquhar is a computer security professional, entrepreneur, and author. He has written professionally about computers since 1991, so he was writing about retro computers when they were still new. He has been working in IT professionally since 1994 and has specialized in vulnerability management since 2013. He holds Security+ and CISSP certifications. Today he blogs five times a week, mostly about retro computers and retro gaming covering the time period from 1975 to 2000.

Very nice! Made Chrome 18.x snappier and reduced the Db size by 20%.