[Digikam-users] Redraw Problems

Andi Clemens andi.clemens at gmx.net
Sat Jun 27 08:22:50 BST 2009 

On Saturday 27 June 2009 08:19:11 Gilles Caulier wrote:
> 2009/6/26 Andi Clemens <andi.clemens at gmx.net>:
> > Yes and that is the problem. Test it with a "big" collection, thumbsDB is
> > way too slow.
> > The startup is slow (in my case it has to open a 160MB db (digikam4.db)
> > and a 890MB db (thumbsDB)), the display is slow, the navigation is slow,
> > changing albums is slow etc... ;-)
>
> 890Mb for thumb... using PGF. Can you imagine the sapce using
> freedesktop (PNG) ? multiply by 2 or 3...

Sure, but that's not the point (for me at last). The problem is that sqlite is 
not able to handle this mass of data correctly as it seems. When digiKam is 
becoming unusable because it is so slow, disk-space is not the main problem we 
have :)
Some users already complained that there are twice the thumbnails now in their 
system, and I can understand this complaint. Applications should all use the 
.thumbnails folder, so we don't have twice the data. But this was never the 
case, somehow thumbnails created with digiKam were never shared / read by 
other applications. So actually nothing changed here :-)
On the other hand we need the ability to have thumbnails for offline images, 
this is why I suggested in the past that only remote collections should use 
the thumbsDB.

>
> > I don't think a thumbsDB is a bad idea, but using sqlite for this might
> > be.
> >
> > Just some startup times (when I just rebooted the system, so nothing is
> > cached, all taken with the same image collection):
> >
> > digiKam 0.9.5   : 4s
> > digiKam 0.10.0 : 13s
> > digiKam 1.0.0   : 22s
>
> And when you switch to freefesktop to host thumb, it reduce times ?

Yes, totally. Still startup is slower than 0.9.5 because the main db is bigger 
now due to the fingerprints table we use now.
I don't know why but for example the loading of imageplugins and kipi-plugins 
has become slower, you can "see" it, but also measure it.
Using callgrind doesn't gave a glue so I don't know why it is like this now, 
but it is absolutely noticeable.

>
> > and it might get worse since the thumbsDB seems to grow forever, at least
> > moving files will not update the tables but create new entries (but this,
> > if a bug, can be changed quite easily).
> >
> > You can't run VACUUM on the thumbsDB because it takes 30min here and
> > takes the same amount of disk space for the journal. In my case the
> > partition would be nearly full if I VACUUM the thumbsDB, and if it fails,
> > I don't know what will happen at all when the journal could not be
> > written?
> >
> > Again, I think a thumbsDB is a good idea, BUT not with sqlite. Like
> > Amarok, we should go with an embedded MySQL and support real database
> > servers as well, like amarok is doing now.
>
> We can use Mysql Qt4 plugin. why using an embeded version of Mysql ?

I thought of embedded because digiKam already has so many dependencies that 
some none KDE-users don't install the KDE4 version anymore. I know some guys 
that switched to F-Spot or picasa because of that. Sure most dependencies come 
from KDE directly, but we also have new ones like Marble etc (and most Distros 
always link against Marble).
>
> Gilles
>
> > Andi
> >
> > On Friday 26 June 2009 22:23:57 Gilles Caulier wrote:
> >> For me, I cannot see any performance problem to use Thumbs database
> >> instead freedesktop cache. I can say that it's a little bit faster.
> >>
> >> But here, i manage local album only with max 250 items (RAW, PNG, and
> >> JPEG)
> >>
> >> My lead computer (production is PIV3.4Ghz - 2Gb RAM - 520 GB Sata HDD)
>
> Forget to said that partition is reiserfs of course...
>
> >> Gilles Caulier
> >>
> >> 2009/6/26 Paul Waldo <paul at waldoware.com>:
> >> > Nope, no difference.
> >> >
> >> > I tried an experiment, though.  I used strace on digikam.  When an
> >> > empty album (My Album) was selected, there are no thumbs to blink.
> >> >  strace is fairly quiet; it is polling for probably what is my Network
> >> > Album that is unavailble.  Once I select an album with thumbnails, the
> >> > blinking starts and I see a huge amount of activity from strace.  It
> >> > appears that digikam is trying to write something to the same file
> >> > handle it was checking before.
> >> >
> >> > Daniel, are you using an offline Album by any chance?
> >> >
> >> > Paul
> >> >
> >> > ----- "Gilles Caulier" <caulier.gilles at gmail.com> wrote:
> >> >> Paul, try invert : -DENABLE_THUMBS_DB=OFF
> >> >>
> >> >> ... because DB thumb is enabled by default now.
> >> >>
> >> >> Gilles
> >> >>
> >> >> 2009/6/26 Paul Waldo <paul at waldoware.com>:
> >> >> > Done.  In essence, no change with -DENABLE_THUMBS_DB=ON
> >> >> >
> >> >> > Paul
> >> >> >
> >> >> > ----- "Gilles Caulier" <caulier.gilles at gmail.com> wrote:
> >> >> >> Please take a look at this entry
> >> >> >>
> >> >> >> https://bugs.kde.org/show_bug.cgi?id=193489
> >> >> >>
> >> >> >> and post your investiguations in this file.
> >> >> >>
> >> >> >> Gilles Caulier
> >> >> >>
> >> >> >> 2009/6/26 Daniel Larsson <opersonlig_postadress at hotmail.com>:
> >> >> >> > I alsoe get this behavior when opening folders. Never thought
> >> >>
> >> >> much
> >> >>
> >> >> >> about it
> >> >> >>
> >> >> >> > as it settles after a minute or two depending on the amount of
> >> >>
> >> >> files
> >> >>
> >> >> >> in the
> >> >> >>
> >> >> >> > folder.
> >> >> >> > I use Ubuntu 9.04 and digiKam 0.10.0.
> >> >> >> >  Havent noticed this behaviour on my Acer with S3 graphichs only
> >> >>
> >> >> on
> >> >>
> >> >> >> the Asus
> >> >> >>
> >> >> >> > with nVidia.
> >> >> >> >
> >> >> >> > Trying to be helpful
> >> >> >> > D.L.
> >> >> >> >
> >> >> >> >> From: marcel.wiesweg at gmx.de
> >> >> >> >> To: digikam-users at kde.org
> >> >> >> >> Date: Thu, 25 Jun 2009 22:28:40 +0200
> >> >> >> >> Subject: Re: [Digikam-users] Redraw Problems
> >> >> >> >>
> >> >> >> >> > • Occasionally thumbnails will blink at me, as if they are
> >> >>
> >> >> being
> >> >>
> >> >> >> >> > continuously redrawn. CPU usage shoots through the roof. I
> >> >>
> >> >> have
> >> >>
> >> >> >> noticed
> >> >> >>
> >> >> >> >> > this with the Album icons, but I see it most with Album
> >> >> >>
> >> >> >> thumbnails
> >> >> >>
> >> >> >> >> There is a bug report for this, but I could never reproduce it.
> >> >> >> >> Which digikam version are you using?
> >> >> >> >> What do you do to restore normal behavior, given you say it
> >> >>
> >> >> happens
> >> >>
> >> >> >> all
> >> >> >>
> >> >> >> >> the
> >> >> >> >> time after restart?
> >> >> >> >> Any console output?
> >> >> >> >>
> >> >> >> >> Marcel
> >> >> >> >> _______________________________________________
> >> >> >> >> Digikam-users mailing list
> >> >> >> >> Digikam-users at kde.org
> >> >> >> >> https://mail.kde.org/mailman/listinfo/digikam-users
> >> >> >> >
> >> >> >> > ________________________________
> >> >> >> > Gör personlighetstestet på MSN Dejting, se vem du passar ihop
> >> >>
> >> >> med!
> >> >>
> >> >> >> MSN
> >> >> >>
> >> >> >> > Dejting
> >> >> >> > _______________________________________________
> >> >> >> > 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
> >> >> >
> >> >> > _______________________________________________
> >> >> > 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
> >> >
> >> > _______________________________________________
> >> > 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
> >
> > _______________________________________________
> > 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

More information about the Digikam-users mailing list