[Digikam-devel] [Bug 96388] show number of images in the album

[Marcel Wiesweg]

------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
         
http://bugs.kde.org/show_bug.cgi?id=96388         




------- Additional Comments From marcel.wiesweg gmx de  2007-11-29 20:59 -------
Physical albums and tags is easy, SQL (for 0.9 dbs):
SELECT COUNT(id) FROM Images WHERE dirid=?;
SELECT COUNT(imageid) FROM ImageTags WHERE tagid=?;

These queries are sufficiently fast, they also can easily be cached in the PAlbum/TAlbum objects.

This can also be done for dates, though potentially a bit slower (we can create an index on creation date for 0.10).

The problem with Searches is that any change in metadata or whatever can affect any search, and that the queries for searches are potentially much slower. So caching is a problem (because you have to listen for everything to keep is up to date), and doing live queries is a problem because it may take longer.