# How to speed up the Smart Location Bar (Awesome Bar)?

The Firefox Awesome Bar is indeed awesome. But, lately I see that it has become slow. On entering some characters it even freezes for a few seconds (freezing the entire browser).

Why does it slow down? Is there a way to speed it up?

(The OS is Windows XP.)

-
What version are you using? –  random Jul 16 '09 at 8:49
I can't find a reference to it now, but I remember reading on one of the mozilla devs blogs that they were looking into this. –  Sam Hasler Jul 16 '09 at 11:27
Yep, Firefox 3.7 should be a bit faster when it comes out. mashable.com/2009/06/29/firefox-next –  TomA Jul 27 '09 at 22:08
What add-ons do you have installed? I'm having the same issue on my home desktop and it even seems to lose keystrokes consistently. I'm wondering if it could be related to a particular add-on. –  Joe Holloway Sep 9 '09 at 13:32

You could VACUUM the SQLite databases that Firefox uses to store it's history and other data. Vacuuming optimizes the database tables inside the files. That speeds up Firefox and saves you some disk space.

To vacuum the Firefox database files:

1. Find the Firefox profile data directory on your system. On Windows Vista, it could be somewhere like C:\Users\tom\AppData\Roaming\Mozilla\Firefox\Profiles\default.jqi\. The directory contains files with the .sqlite extension, so you can find it by searching for those.

2. Get the SQLite command line utility here.

3. Close all Firefox windows. Open a command line in the profile directory.

4. On Windows, type in the command for %i in (*.sqlite) do @echo VACUUM; | sqlite3 %i On Linux or Mac, run for i in *.sqlite; do echo "VACUUM;" | sqlite3 \$i ; done

Google Chrome actually uses SQLite as well, except it doesn't give the files the .sqlite extension. You can still safely run the same command for all the files in the Chrome profile directory and SQLite will only VACUUM the files it recognizes.

-
On a Mac: ~/Library/Application\ Support/Firefox/Profiles/*.default/ (see superuser.com/questions/3275/firefox-on-mac-slow-slow-slow/…) –  Arjan Aug 18 '09 at 9:17
Is there any reason you're putting VACUUM in both bold and all-uppercase? –  Hello71 Mar 14 '11 at 15:56
@Hello71: nope. I'm just used to writing SQL keywords in uppercase for better readability. Lowercase should work fine. –  TomA Mar 15 '11 at 9:40

It is easier to install the Vacuum Places addon which allows you to defragment the Places database with the click of a button.

You used to be able to run the command:

Components.classes["@mozilla.org/browser/nav-history-service;1"].getService(Components.interfaces.nsPIPlacesDatabase).DBConnection.executeSimpleSQL("VACUUM");


in the "Error Console" to vacuum the database, but I'm not sure it works in Firefox 3.6.

-

If using you're using 3.0 upgrade to 3.5.

-

This is because you have a lot of pages history. Clearing history every once in a while helps with this.

-
Doesn’t that somewhat diminish the awesomeness of the awesome bar. –  Jeremy French Jul 16 '09 at 11:21

Well the awesome bar queries your history, bookmarks and recent search terms (from the same bar) so perhaps you've got a lot of data in there. Try clearing out your history (from a month back onwards if you'd like to keep recent history) and emptying your search history - 3.5 has a useful tool for this (that can clear up to a set date). This should speed up your query times if there's less data.

-

It does seem to be a pretty intensive thing for the computer to do. I have noticed that it is much slower when my PC is under heavy load.

Have you installed anything recently that could be eating up resources? You could just try closing a few programs, freeing up disk space, etc. It could just be a symptom of a pc that is getting overwhelmed.

-

On Linux you could use tmpfs to mount part of the filesystem in memory. (Ironically, of course, one of SQLite's best features is its ability to store an entire database in memory in the first place.)

Wikipedia suggests an alternative to tmpfs for Windows, but it doesn't go into details and it feels somewhat hacky. YMMV.

-

This works just fine for me:

cd ~/.mozilla/firefox/????????.default
echo "VACUUM;" | sqlite3 places.sqlite


The idea is VACUUMing, as suggested, only places.sqlite.

-

The code behind it needs some extra work. You could somewhat work-around it temporarily in a numerous ways suggested here, but really, the only way to fix this is for the code to be improved.

To me this bar is not awesome at all, because half the time I can't even finish typing a darn website name without the UI completely locking up for seconds. Very disappointing.

-

The Places Maintenance extension has a UI that allows easy vacuuming (optimization) of Firefox database files, which should help speed up the Awesome Bar and other Firefox database access. It also has other Firefox database maintenance functions:

Allows to run Maintenance tasks on the database that drives Places, the bookmarks and history module behind Firefox.

-