Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Speed up Firefox by cleaning up places.sqlite' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Speed up Firefox by cleaning up places.sqlite
Authored by: palahala on Mar 05, '09 12:01:15PM

I have not been keeping track of figures such as in this hint, but my Firefox seemed to be stalling when playing certain Flash content. For example, some content that was mentioned in some Dutch forum, always paused for half a second at some specific point -- even when replaying after the content had been fully downloaded. I experienced the same with other content. Also, scrolling down using the trackpad would often show the spinning wait cursor for a few seconds. And shutting down Firefox also took a long time.

I keep my browsing history for "at least 90 days", and my Firefox's places.sqlite file (holding both history and bookmarks) had grown to over 20MB. (As a side note, I noticed this because my Time Machine backup would always be at least 20 MB, and used TimeTracker to find out what caused that.)

Vacuuming seemed to improve playback of flash movies and shutdown speed (first close Firefox before doing this):

cd ~/Library/Application Support/Firefox/Profiles/*.default/ 
ls -la places.*
sqlite3 places.sqlite "vacuum;"

Maybe the slow shutting down of Firefox was caused by the need to merge places.sqlite-journal into places.sqlite?

On the other hand: I still did not find a definitive answer if the vacuuming really helps there -- for some time I thought that maybe clearing the actual cache had better results. Though I could restore my large places.sqlite from a backup, the caches are not being backed up, so could not be restored for testing. Also playing with the Flash privacy settings seemed to have some effect, but often enforcing a stricter privacy would only make things not work at all...



[ Reply to This | # ]
Speed up Firefox by cleaning up places.sqlite
Authored by: palahala on May 25, '09 07:50:49AM

The first line is missing the escape character for the space in the path. So, when using copy and paste, use the following instead:

cd ~/Library/Application\ Support/Firefox/Profiles/*.default/
ls -lh places.*
sqlite3 places.sqlite "vacuum;"
ls -lh places.*

When the cd-command fails, the 3rd line will in fact create a new 1024 byte database file places.sqlite in the current folder. That file is not used by Firefox of course, so may be deleted.

[ Reply to This | # ]