[Digikam-devel] [Bug 96388] show number of images in the album
marcel.wiesweg at gmx.de
Tue Dec 11 22:19:13 GMT 2007
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
------- 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.
More information about the Digikam-devel