[Digikam-devel] [Bug 155097] performance problems with recursive view and filtering

[Andi Clemens]

http://bugs.kde.org/show_bug.cgi?id=155097





--- Comment #12 from Andi Clemens <andi clemens gmx net>  2008-09-04 08:26:44 ---
I made a progress, after testing code with callgrind for hours, there is only
one conclusion left: We need to filter with custom SQL statements here. I have
implemented filtering with text quickfilter right now and my album with 3600
images can be filtered in less than a second.
The old way is just not usable, because it queries the database for every
single image. But not only one value, it queries up to 8. If every quickfilter
is enabled, we make over 24000!! SQL queries. This is way too much. Right now
it is only one ;-)
But I need to adopt this for the other filters first.
Also we filtered the list when the kio-slaves (digikamalbums) delivered the
images, that is ok in general, BUT we filtered everything again in a second
step, which is not ok.
Another problem: We also filtered everything although no quick filter was ever
set, and again this happened twice.
So by just displaying an album we filtered images, that shouldn't be filtered
anyway.
This has been removed right now.

Gilles,

when I'm done with the patch I think we need to talk about some points that I'm
unsure right now :-)

Andi


-- 
Configure bugmail: http://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.