Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Firefox version: 3.6

My places.sqlite is rather big (114MB, after being optimized by SpeedyFox.) If I turn on auto-complete, it may take 1 or 2 seconds for Firefox to accept a newly typed URL. To reproduce the issue:

  1. Type a URL into the URL bar, press enter.
  2. Nothing happens, and Firefox consumes 100% CPU (actually 50% of 2 cores) for 1 to 2 seconds
  3. Then Firefox start the network connection and load the webpage.

Since it consumes 100% CPU, I don't think the bottleneck is the disk. I have some experience with SQLite and I know a 100MB DB is very small. To achieve the delay Firefox must be doing some expensive processing or inefficient queries.

The issue does not appear if:

  1. auto-complete is turned off, or
  2. the URL is frequently used, or
  3. a new profile with no history is used

Does anyone have any idea how to solve the problem? Should I file this as a bug? I don't want to give up my 100MB history, but I don't want to give up auto-complete either :)

share|improve this question

Try this addon: | It is not a bug, 'its a feature'. ;) There is an other addon, but you may have to edit its compat info to make it work with 3.6. If you dont know how, just ask. >>

share|improve this answer
The add-on you've mentioned is similar to SpeedyFox. Basically they both execute "VACUUM" on the sqlite3 database. The problem that I'm talking about is the (probably avoidable) inefficiency in auto-complete. Does it make sense? – netvope Jan 30 '10 at 11:34
To be honest I experienced this 1-2second problem, WHEN I installed some new addons and themes. Could you try this out on a new profile? (Of course bringing your places file, but leaving the other stuff.) – Shiki Jan 30 '10 at 13:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.