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