[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-bugs-dist
Subject:    [Bug 96388] show number of images in the album
From:       Marcel Wiesweg <marcel.wiesweg () gmx ! de>
Date:       2007-12-11 22:19:14
Message-ID: 20071211221914.25571.qmail () ktown ! kde ! org
[Download RAW message or body]

------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.
         
http://bugs.kde.org/show_bug.cgi?id=96388         




------- Additional Comments From marcel.wiesweg gmx de  2007-12-11 23:19 -------
I usually write the JOIN explicitly:

SELECT ImageTags.tagid, Images.name FROM ImageTags LEFT JOIN Images ON \
ImageTags.imageid=Images.id;

which gives the same result. A real SQL guru could explain the difference.

It is the right way to go here to limit the number of SQL queries to speed things up \
(as long as the result set is not too large for memory ;-) ) A query always involves \
much more computing work than accessing structures in memory.

And I have a much better feeling now that you removed search counting. The other \
three can be handled, but searches get complex (as testing has proved). I will have \
time tomorrow to test the patch, finally.


[prev in list] [next in list] [prev in thread] [next in thread]