[digiKam-users] debugging slow startup on Windows

[Randy Wolf]

Using debugview I can see that about half of the startup time is spent with
" Attempt to create invalid tag pair image id 129117 tag id 0" database...
errors?

Any thoughts on what might be causing this or how to improve?
Thanks!

...
[10496]  "SELECT DISTINCT Images.id, Images.name, Images.album,
 Albums.albumRoot,        ImageInformation.rating, Images.category,
 ImageInformation.format, ImageInformation.creationDate,
 Images.modificationDate, Images.fileSize,        ImageInformation.width,
 ImageInformation.height,        ImageTagProperties.value,
ImageTagProperties.property, ImageTagProperties.tagid  FROM Images
 INNER JOIN ImageTagProperties ON ImageTagProperties.imageid=Images.id
   LEFT JOIN ImageInformation ON Images.id=ImageInformation.imageid
 INNER JOIN Albums           ON Albums.id=Images.album WHERE
Images.status=1 AND (  ( ( (ImageTagProperties.tagid=? OR
ImageTagProperties.tagid IN (SELECT id FROM TagsTree WHERE pid=?)) AND
ImageTagProperties.property=?  ) OR ( (ImageTagProperties.tagid=? OR
ImageTagProperties.tagid IN (SELECT id FROM TagsTree WHERE pid=?)) AND
ImageTagProperties.property=?  ) OR ( (ImageTagProperties.tagid=? OR
ImageTagProperties.tagid IN (SELECT id FROM TagsTree WHERE pid=?)) AND
ImageTagProperties.property=?  ) OR ( (ImageTagProperties.tagid=? OR
ImageTagProperties.tagid IN (SELECT id FROM TagsTree WHERE pid=?)) AND
ImageTagProperties.property=?  ) )  );"
[10496]  (QVariant(int, 215), QVariant(int, 215), QVariant(QString,
"autodetectedPerson"), QVariant(int, 215), QVariant(int, 215),
QVariant(QString, "autodetectedFace"), QVariant(int, 215), QVariant(int,
215), QVariant(QString, "ignoredFace"), QVariant(int, 215), QVariant(int,
215), QVariant(QString, "tagRegion"))
[10496] digikam.database: Search result: 779
[10496] digikam.geoiface: "ROADMAP"
[10496] digikam.geoiface: ----
[10496] digikam.geoiface: ----
[10496] digikam.general: One job is done
[10496] digikam.general: One job is done
[10496] digikam.general: Cancel Main Thread
[10496] digikam.general: One job is done

"errors" start

[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
132467 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
132467 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
132467 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
132467 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
132467 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
132467 tag id 0
[10496] digikam.geoiface: ----
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0
[10496] digikam.database: Attempt to create invalid tag pair image id
129117 tag id 0

"errors" end, rest of startup continues...

[10496] digikam.metaengine: ExifTool path: "C:/Program
Files/digiKam/exiftool.exe"
....
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20220614/7b0293c5/attachment.htm>