On Tue, May 26, 2009 at 7:43 PM, Richard (MQ)
Vahis wrote:
Sankar P wrote:
<snip>
Firefox becomes a hog over long usage (few months). The sqlite database after getting bloated will cause serious delays in startup.
You can shutdown firefox and from the ~/.mozilla directory run:
find . -name '*.sqlite' -exec sqlite3 '{}' 'VACUUM;' \;
This will compact the disk blocks of your sqlite database and from then on, firefox will start noticeably faster if your are a long time user. <snip> A big hand to you :)
I couldn't resist to try that, and, wow! That was cool shit. My installation is about a year old 11.0 and that really made FF run nicely.
+1 - my /home and therefore Firefox config is years old and was getting really slow. Now it just zips. What other apps would benefit from this?
Any application that uses sqlite (not mysql) will benefit from it. sqlite is a light-weight in-process db. You just have to give the correct filename. For evolution, the sqlite db is stored as 'folders.db' under ~/.evolution sub-folders For amarok and other applications, you need to find out the filenames and paths where the database is stored; and run vacuum on them. Or you can help the individual app. developers get in touch with sticktac so that he can update his vacuumizer script to include them.
Many thanks from me, too!
:-) -- Sankar P http://psankar.blogspot.com -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-factory+help@opensuse.org