[Digikam-users] lots of photos and startup time

[Gilles Caulier]

Marcel, Andi,

All this thread tell me that we need to found urgently a solution to
this problem.

If sqlite cannot drive large database, another DB backend need to be
used. For me MySql sound like the right alternative, if performance
are there of course (how to make a quick test about ?)

About DB schema and all DB queries, it's really complicated to migrate
from SQLite to MySql. SQL syntax is really different between both DB
backend ?

Gilles

2009/7/9 Daniel Larsson <opersonlig_postadress at hotmail.com>:
> 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
>
> ________________________________
> Dela foton på ett smidigt sätt med Windows LiveT Photos. Dra och släpp
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>
>