[Digikam-users] lots of photos and startup time

[Andi Clemens]

And another guess:

Maybe your database file is somehow corrupted?
Can you try the following?

1. in /usr/bin, there should be a script called cleanup_digikamdb, run it
2. if you have not such a script, open your database file with the sqlite CLI:
    $ sqlite3 /path/to/images/digikam4.db

    and then run
    VACUUM; 

    inside the sqlite3 shell.

digiKam should be closed, before doing this.

Andi

On Wednesday 08 July 2009 12:57:50 Andi Clemens wrote:
> Ok one thing that causes bad performance with ext4 is the use of barriers.
> If you are running ext4 with barriers turned on, try to add the following
> mount option to the fstab:
>
> barrier=0
>
> sqlite performs bad with barriers, because it creates a lot of journal
> files in a short time, with barriers enabled it can kill the performance. I
> usually only had issues when moving files inside of digiKam, not on
> startup. But maybe this helps.
>
> Andi
>
> On Wednesday 08 July 2009 12:43:42 Daniel Larsson wrote:
> > Yes, I am serious. I do not think that the partition is bad or the  HDD
> > is about to die, non of the drives I use are older than 2 years. FS is
> > EXT4. Maby you are right about the broken system but I only notice it in
> > digiKam. Maby I have to reinstall the system but it wount be this week as
> > I am suposed to give two lectures on digiKam this week.
> >
> > > From: andi.clemens at gmx.net
> > > To: digikam-users at kde.org
> > > Date: Wed, 8 Jul 2009 10:43:14 +0200
> > > Subject: Re: [Digikam-users] lots of photos and startup time
> > >
> > > On Wednesday 08 July 2009 10:22:16 Daniel Larsson wrote:
> > > > IMHO the 2 seconds mor or less with splash enabled is not to much to
> > > > bother about.
> > > >
> > > > I think the real time savings can be made in read and write
> > > > performance to the db.
> > > >
> > > > All gains in performance is welcome but in my case I want a reduction
> > > > in minutes before bothering with seconds.
> > > >
> > > >
> > > >
> > > > On my Ubuntu Studio 9.04 system I have now installed their kernel
> > > > 2.6.31 rc2 and start time is reduced considerably. From close to one
> > > > houer to mere five minutes. Flickering has reapperd but settles fast.
> > >
> > > One hour? Seriously?
> > > Then your system is broken, this is really not normal.
> > > Even with reiserFS I had never such bad startup times.
> > > Not even 5 Minutes.
> > > DB access has been improved already and this is not what slows down the
> > > startup so much, we don't query a lot during the application starts.
> > >
> > > I really would consider to try another filesystem, or run a check (with
> > > badblocks if possible), maybe the partition you use is about to die?
> > >
> > > Andi
> > >
> > > _______________________________________________
> > > Digikam-users mailing list
> > > Digikam-users at kde.org
> > > https://mail.kde.org/mailman/listinfo/digikam-users
> >
> > _________________________________________________________________
> > Vi vet vem du passar ihop med! Klicka här för att få veta!
> > http://dejting.se.msn.com/channel/index.aspx?trackingid=1002952
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users