Mailinglist Archive: opensuse-factory (257 mails)

[Sankar P <sankar.curiosity@xxxxxxxxx>]

On Tue, May 26, 2009 at 7:43 PM, Richard (MQ) <osl2008@xxxxxxxxxxxxxx> wrote:
> 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@xxxxxxxxxxxx
For additional commands, e-mail: opensuse-factory+help@xxxxxxxxxxxx