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

[Rainer Lay]

https://bugs.kde.org/show_bug.cgi?id=324287

            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
each.
--
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
this.

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
DS213+).

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