[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:       chiefaua <tom_t () gmx ! at>
Date:       2007-12-12 17:00:15
Message-ID: 20071212170015.17994.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 tom_t gmx at  2007-12-12 18:00 -------
About #77

IMO, all three queries should have the same performance.

I would probably use

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


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