Make Firefox Faster by Vacuuming Your Database
October 2, 2009 Computer Tips And Tricks
Firefox tip: Firefox 3.0′s Awesome Bar added all kinds of features to it, but unfortunately it’s also caused some big 
issues which is causing everything to sometimes completely malfunction.
All-things-Firefox weblog Mozilla Links previously detailed how to defragment SQLite databases with a vacuum command, but the whole process was a bit clumsy, and it required a restart. Now they’ve updated the technique with a simple bit of code you can run inside Firefox’s Error Console that requires no restart.
• Open the Error Console: ‘Tools’ menu / ‘Error Console’
• In the ‘Code’ text box paste this (it’s a single line):
• Components.classes["@mozilla.org/browser/nav-history-service;1"].getService(Components.interfaces.nsPIPlacesDatabase).DBConnection.executeSimpleSQL(“VACUUM”);
• Press ‘Evaluate’. All the UI will freeze for a few seconds while databases are Vacuumed
Once the process is finished, you will see a huge improvement in performance.
