https://bugs.kde.org/show_bug.cgi?id=515061
Bug ID: 515061
Summary: Speed up startup
Classification: Applications
Product: digikam
Version First 8.8.0
Reported In:
Platform: Microsoft Windows
OS: Microsoft Windows
Status: REPORTED
Severity: normal
Priority: NOR
Component: Database-Mysql
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
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
--
You are receiving this mail because:
You are watching all bug changes.
