Compacting SQLite bases of Firefox 3

SQLite?

Firefox 3 uses SQLite database to store the history, bookmarks, the anti-phishing, etc..
SQLite is a database very powerful.

This helps to provide excellent performance, very fast search and ensure that data will not be corrupted.
The disadvantage is that these bases SQLite bigger and take place. Firefox does not compact these databases regularly.
These are the files. Sqlite content in your Firefox profile (home directory).

Here is a manipulation that reduces the size of these files without any loss of data.
This manipulation does no data base: It is fair to claim the unused disk blocks SQLite files.

Download SQLite

• Under Linux, Install the sqlite3 packet (for example, under Debian/Ubuntu: sudo apt-get installe sqlite3)
• Under Windows, download this command tools: http://www.sqlite.org/sqlite-3_5_9.zip

Optimizing

Close Firefox (important)

Then type:

sqlite databasename.sqlite "VACUUM" 

(For example: sqlite urlclassifier3.sqlite "VACUUM")

The size of the SQLite files should be decrease

Batch

To optimize all SQLite files , here is a batch for Windows:

@FOR %%G IN (*.sqlite) DO ( sqlite3 %%G "VACUUM" )

You can copy this file. Def (and sqlite3.exe) in the directory containing your files .Sqlite and run from time to time.