[Digikam-devel] [digikam] [Bug 324287] New: frequent image scans slow with mysql

Rainer Lay rainer.lay at gmx.de
Fri Aug 30 20:15:05 BST 2013


            Bug ID: 324287
           Summary: frequent image scans slow with mysql
    Classification: Unclassified
           Product: digikam
           Version: 3.2.0
          Platform: Ubuntu Packages
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database
          Assignee: digikam-devel at kde.org
          Reporter: rainer.lay at gmx.de

on startup, the following sql is executed serveral times, which costs ~5 sec
SELECT creationDate FROM ImageInformation  INNER JOIN Images ON
Images.id=ImageInformation.imageid  WHERE Images.status=1;
also, when I import pictures, this sql is executed for every imported picture
(5sec each!).

I just wonder, why the creation datefor all pictures (80.000 in thi collection)
is neccesary that much. Since this costs my lots of time, please have a look at

For your information: the sql itselve is very fast, but fetching the 80.000
creationDates costs the 5 sec,even when I fetch them on the server (synology

You are receiving this mail because:
You are the assignee for the bug.

More information about the Digikam-devel mailing list