SUMMARY The startup of digikam is a little too slow. It takes like 25 seconds if I use mySql. I just noticed that it seems to depend by a huge number of queries the program does for every picture (it perform 8604 times with different ID this query: "SELECT Images.name, Albums.albumRoot, Albums.relativePath, Albums.id FROM Images INNER JOIN Albums ON Albums.id=Images.album WHERE Images.id=" Is there some way to avoid this? Maybe loading a part on windows startup or asking to the program to don't do all these check at startup. Thanks STEPS TO REPRODUCE 1. Startup digikam program with mySql DB 2. Turn on Log on mySQL with SET GLOBAL GENERAL-LOG='ON'; 3. Check the file in C:\Program Files\MariaDB 11.7\data\[COMPUTERNAME].log OBSERVED RESULT Many db search EXPECTED RESULT Less db search -> Faster startup SOFTWARE/OS VERSIONS Windows: Windows 10 macOS: (available in the Info Center app, or by running `kinfo` in a terminal window) Linux/KDE Plasma: KDE Plasma Version: KDE Frameworks Version: Qt Version: ADDITIONAL INFORMATION Things like this are duplicated many times 160 Execute SELECT tagid FROM ImageTags WHERE imageID=48258 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=21 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=31 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=226 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=231 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=244 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=247 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=275 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=293 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=316 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=350 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=354 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=401 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=405 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=417 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=443 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=960 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=1168 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=1171 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=1172 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=1173 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=1174 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=1176 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=1178 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=1179 160 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=1358 160 Close stmt 168 Prepare SELECT Images.name, Albums.albumRoot, Albums.relativePath, Albums.id FROM Images INNER JOIN Albums ON Albums.id=Images.album WHERE Images.id=? 168 Reset stmt 168 Execute SELECT Images.name, Albums.albumRoot, Albums.relativePath, Albums.id FROM Images INNER JOIN Albums ON Albums.id=Images.album WHERE Images.id=54014 168 Close stmt 160 Prepare SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=? AND tagid=? 160 Reset stmt 160 Execute SELECT tagid, property, value FROM ImageTagProperties WHERE imageid=48258 AND tagid=1359
Did you double check first if all startup options from the Setup/Miscs/Behaviors are turn off: https://docs.digikam.org/en/setup_application/miscs_settings.html#behavior-settings
Do we simply omit database queries, and digiKam will function just like before, only faster? These queries are necessary and certainly not the issue in terms of speed. Please create a DebugView log from the start of digiKam, as described here for Windows: https://www.digikam.org/contribute/#windows-host Maik
(In reply to caulier.gilles from comment #1) > Did you double check first if all startup options from the > Setup/Miscs/Behaviors are turn off: > > https://docs.digikam.org/en/setup_application/miscs_settings.html#behavior- > settings Yes, they are all off
Created attachment 188869 [details] Log file Log file from debugview