<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
I have run VACUUM on the database and put barrier=0 in fstab.<BR>
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.<BR>
<BR>
/D.L.<BR> <BR>> From: andi.clemens@gmx.net<BR>> To: digikam-users@kde.org<BR>> Date: Wed, 8 Jul 2009 14:39:49 +0200<BR>> Subject: Re: [Digikam-users] lots of photos and startup time<BR>> <BR>> And another guess:<BR>> <BR>> Maybe your database file is somehow corrupted?<BR>> Can you try the following?<BR>> <BR>> 1. in /usr/bin, there should be a script called cleanup_digikamdb, run it<BR>> 2. if you have not such a script, open your database file with the sqlite CLI:<BR>> $ sqlite3 /path/to/images/digikam4.db<BR>> <BR>> and then run<BR>> VACUUM; <BR>> <BR>> inside the sqlite3 shell.<BR>> <BR>> digiKam should be closed, before doing this.<BR>> <BR>> Andi<BR>> <BR>> On Wednesday 08 July 2009 12:57:50 Andi Clemens wrote:<BR>> > Ok one thing that causes bad performance with ext4 is the use of barriers.<BR>> > If you are running ext4 with barriers turned on, try to add the following<BR>> > mount option to the fstab:<BR>> ><BR>> > barrier=0<BR>> ><BR>> > sqlite performs bad with barriers, because it creates a lot of journal<BR>> > files in a short time, with barriers enabled it can kill the performance. I<BR>> > usually only had issues when moving files inside of digiKam, not on<BR>> > startup. But maybe this helps.<BR>> ><BR>> > Andi<BR>> ><BR>> > On Wednesday 08 July 2009 12:43:42 Daniel Larsson wrote:<BR>> > > Yes, I am serious. I do not think that the partition is bad or the HDD<BR>> > > is about to die, non of the drives I use are older than 2 years. FS is<BR>> > > EXT4. Maby you are right about the broken system but I only notice it in<BR>> > > digiKam. Maby I have to reinstall the system but it wount be this week as<BR>> > > I am suposed to give two lectures on digiKam this week.<BR>> > ><BR>> > > > From: andi.clemens@gmx.net<BR>> > > > To: digikam-users@kde.org<BR>> > > > Date: Wed, 8 Jul 2009 10:43:14 +0200<BR>> > > > Subject: Re: [Digikam-users] lots of photos and startup time<BR>> > > ><BR>> > > > On Wednesday 08 July 2009 10:22:16 Daniel Larsson wrote:<BR>> > > > > IMHO the 2 seconds mor or less with splash enabled is not to much to<BR>> > > > > bother about.<BR>> > > > ><BR>> > > > > I think the real time savings can be made in read and write<BR>> > > > > performance to the db.<BR>> > > > ><BR>> > > > > All gains in performance is welcome but in my case I want a reduction<BR>> > > > > in minutes before bothering with seconds.<BR>> > > > ><BR>> > > > ><BR>> > > > ><BR>> > > > > On my Ubuntu Studio 9.04 system I have now installed their kernel<BR>> > > > > 2.6.31 rc2 and start time is reduced considerably. From close to one<BR>> > > > > houer to mere five minutes. Flickering has reapperd but settles fast.<BR>> > > ><BR>> > > > One hour? Seriously?<BR>> > > > Then your system is broken, this is really not normal.<BR>> > > > Even with reiserFS I had never such bad startup times.<BR>> > > > Not even 5 Minutes.<BR>> > > > DB access has been improved already and this is not what slows down the<BR>> > > > startup so much, we don't query a lot during the application starts.<BR>> > > ><BR>> > > > I really would consider to try another filesystem, or run a check (with<BR>> > > > badblocks if possible), maybe the partition you use is about to die?<BR>> > > ><BR>> > > > Andi<BR>> > > ><BR>> > > > _______________________________________________<BR>> > > > Digikam-users mailing list<BR>> > > > Digikam-users@kde.org<BR>> > > > https://mail.kde.org/mailman/listinfo/digikam-users<BR>> > ><BR>> > > _________________________________________________________________<BR>> > > Vi vet vem du passar ihop med! Klicka här för att få veta!<BR>> > > http://dejting.se.msn.com/channel/index.aspx?trackingid=1002952<BR>> ><BR>> > _______________________________________________<BR>> > Digikam-users mailing list<BR>> > Digikam-users@kde.org<BR>> > https://mail.kde.org/mailman/listinfo/digikam-users<BR>> <BR>> _______________________________________________<BR>> Digikam-users mailing list<BR>> Digikam-users@kde.org<BR>> https://mail.kde.org/mailman/listinfo/digikam-users<BR><br /><hr />Dela foton på ett smidigt sätt med Windows LiveT Photos. <a href='http://www.microsoft.com/windows/windowslive/photos.aspx' target='_new'>Dra och släpp</a></body>
</html>