Firefox 3 slow? Time to vacuum the database…
From mozillalinks.org
A few months ago, I posted how to improve Firefox performance by defragmenting its database files executing SQLite VACUUM command. The only con was that it required a Firefox restart to execute the command.
Thanks to Mozilla’s Jeremy Orem, we have now learned it can be done from within Firefox in two short steps:
* 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
Note however that the procedure optimizes the Places database only, but this is precisely where you will get the most significant performance improvements.


