[Digikam-users] Redraw Problems

[Gilles Caulier]

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...

> 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 ?

>
> 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 ?

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
>