[Digikam-users] Write Metadata takes long time

[Daniel Larsson]

If sqlite3 is slow how about a change to mysql? I have a faint memory that this change was discussed some time ago. I have tested with and without barriers but the "20times slower" is not true on my hardware. Only a few % in difference. A think sqlite3 handles small amounts of data, up to ~30 000 pictures well, but I have over 450 000 pictures on my drives and then its slow, realy slow. 

My point here is that not only barriers on or off matters but also the size of the db.

/ D.L.

> From: andi.clemens at gmx.net
> To: digikam-users at kde.org
> Date: Mon, 22 Feb 2010 20:52:52 +0100
> Subject: Re: [Digikam-users] Write Metadata takes long time
> 
> The "20times slower" is only true for my hardware of course, no general 
> assumption... :-)
> 
> 
> On Monday 22 February 2010 20:47:40 Andi Clemens wrote:
> > What filesystem are you using? All barrier-enabled filesystems will be slow
> > as hell with sqlite3 or in general heavy disk usage.
> > 
> > Filesystems that will be 20times slower for example are:
> > EXT4 (barriers on)
> > XFS (barriers on)
> > 
> > If you are using one of the above FS, try disabling barriers:
> > 
> > EXT4:
> > mount -o defaults,rw,barrier=0,async,noatime,nodiratime
> > 
> > XFS:
> > mount -o defaults,rw,nobarrier,async,noatime,nodiratime,logbufs=8
> > 
> > Andi
> > 
> > On Friday 19 February 2010 14:20:10 Juergen wrote:
> > > Hallo.
> > > 
> > > I have the problem that it takes a long time for digikam to write
> > > metadate into files.
> > > 
> > > Technical details are :
> > > 
> > > Suse 11.0
> > > 
> > > AMD : Linux linux-4qg7 2.6.25.20-0.6-default #1 SMP 2010-01-14 18:58:36
> > > +0100 x86_64 x86_64 x86_64 GNU/Linux
> > > 
> > > KDE 3.5.9 "release 49.2"
> > > 
> > > Digikam : V 1.1.0 with KDE Version 4.4.0 release 224
> > > 
> > > So, back to my problem.
> > > 
> > > Downloading images from my kardreader takes much longer than it did in
> > > previous versions. But, I can not tell you exact how long that is.
> > > 
> > > But, what makes the current version useless for me is that it takes so
> > > long to write tags into my image files.
> > > 
> > > It almost an hour to write just one Tag : Special->Original to 111
> > > images.
> > > 
> > > The images are JPG images taken with my "Nikon D90" and they are about 3
> > > - 6 MB big.
> > > 
> > > For 12 Images to get one new tag added it took 3,44 minutes.
> > > 
> > > My settings regarding metadata are :
> > > 
> > > Rotate preview images according exif information
> > > Set exif information to normal after rotation
> > > Save image tags as "Keywords" tags embedded in metadata in files
> > > Save image captions in metadata in files
> > > Save image timestamp in metadata in files.
> > 
> > _______________________________________________
> > 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
 		 	   		  
_________________________________________________________________

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20100225/dca66d1a/attachment.html>