Optimizing the Firefox (SQLite databases)

Most people that want to speed up Firefox know about the various settings in about:config but many forget that Firefox uses SQLite databases that can become cluttered.

In your home directory ($HOME on *nix/Mac and %APPDIR% on Windows), run sqlite3 with vacuum, reindex and analyze on each of the *.sqlite databases. Don’t have sqlite3? No problem, get it from the SQLite Download page or your distribution’s package manager (e.g. apt-get install sqlite3)

#!/bin/bash

cd ${HOME}/.mozilla/firefox/

for profile in *.default; do
    cd ${profile}

    for db in *.sqlite; do 
        echo Processing $db
        sqlite3 "${db}" <<EOD
vacuum;
reindex;
analyze;
EOD
    done
doen

That wasn’t hard was it? 🙂

Share Button

One Reply to “Optimizing the Firefox (SQLite databases)”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.