Vacuuming Firefox’s sqlite3 databases
Firefox 3 was running very slow for me, so I desperately tried this, thinking that it wouldn’t make much difference. I was wrong; there was a noticeable speed improvement. From a bash shell:
find ~/.mozilla -iname '*.sqlite' -execdir sqlite3 {} 'vacuum;' \;
