[Digikam-users] lots of photos and startup time

[Daniel Larsson]

I have run VACUUM on the database and put barrier=0 in fstab.

It is still extremely slow on start with this 687 MB large db but start in seconds when i start with a 2.1 MB large db with my pictures on the internal disc. To me this sugest that either digiKam is bad att handeling large databases or my databas is still corupt. I will rebuild the entire database to se if this helps.

 

/D.L.
 
> From: andi.clemens at gmx.net
> To: digikam-users at kde.org
> Date: Wed, 8 Jul 2009 14:39:49 +0200
> Subject: Re: [Digikam-users] lots of photos and startup time
> 
> 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
> 
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users

_________________________________________________________________
Vårkänslor och pirr i magen? Hitta din drömpartner här!
http://dejting.se.msn.com/channel/index.aspx?trackingid=1002952
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20090709/20baaf83/attachment.html>