Articles

Use Firefox 3? You’ll need to Vacuum the database once in a while.

In Computers, Linux, Typical on 2009-01-17 by petervk

So, fancy new Firefox 3 uses a sweet new database to manage all your history & bookmarks. Which can make for awesomely fast bookmarks and awesome bar usage for the first little while. The only problem is that the database in use is Sqlite3, which has one minor problem for Firefox 3 users: it becomes clogged with dust.

Well it isn’t actually dust, but stale indexes, and the like. The solution is to Vacuum the database.

On Ubuntu you’ll have to navigate to your Firefox profile folder in a terminal. So launch a terminal.

cd .mozilla/firefox/
ls

Now look for a folder called “(randomcharacters).default”
For example it could be called “1g8uequb.default”

cd (folder name above)
Now copy the line below to a text file because you’ll have to shut down Firefox to complete the next step.

Shut down firefox and run the following command.
for i in *.sqlite; do echo "VACUUM;" | sqlite3 $i ; done

It won’t output anything if it runs correctly and should take a minute or two before it returns you to the terminal. If you get a “SQL error near line 1: database is locked” then Firefox is still running. Wait a second and try the command above again.

Launch Firefox up again and appreciate the new found snappiness.

Taken from: http://www.gettingclever.com/2008/06/vacuum-your-firefox-3.html

Advertisements

6 Responses to “Use Firefox 3? You’ll need to Vacuum the database once in a while.”

  1. This doesn’t have to be technical. BleachBit is an easy way to vacuum Firefox from a GUI and perform other system cleaning tasks with just a click

  2. […] Use Firefox 3? You’ll need to Vacuum the database once in a while. « Peter Vand… […]

  3. […] seen a few posts about VACUUMing Firefox’s sqlite database for better performance, but each requires Firefox […]

  4. […] seen a few posts about VACUUMing Firefox’s sqlite database for better performance, but each requires Firefox […]

  5. Good :=)

  6. Is this still a necessary thing to do (if you want a faster FF), or is the new and updated version better?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: