Bug 502074 - Extremely slow loading of db on startup
Summary: Extremely slow loading of db on startup
Status: REPORTED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Sqlite (other bugs)
Version First Reported In: 8.7.0
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-03-27 15:26 UTC by Atle Bjanes
Modified: 2025-04-11 20:43 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed/Implemented In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Atle Bjanes 2025-03-27 15:26:33 UTC
***
If you're not sure this is actually a bug, instead post about it at https://discuss.kde.org

If you're reporting a crash, attach a backtrace with debug symbols; see https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports

Please remove this comment after reading and before submitting - thanks!
***

SUMMARY
My database is stored locally - files on network. When starting digiKam, it takes +5 minutes until UI is open.

Database is approx 16GB

digikam version 8.5.0
Images: 
BMP: 5834
FTS: 1
GIF: 1562
HEIF: 516
ICO: 1316
JPEG: 3
JPG: 384308
PCX: 230
PGF: 2
PNG: 6120
PSB: 1
PSD: 23
RAW-CAP: 6
RAW-CR2: 13256
RAW-DCR: 7
RAW-DNG: 323
RAW-HDR: 14
RAW-MDC: 1
SGI: 2
TGA: 1
TIFF: 248
WEBP: 77
WMF: 2
XCF: 1
total: 413854
: 
Videos: 
3GP: 4
AVI: 231
MOV: 21604
MP4: 946
MPEG: 11
MTS: 2
WMV: 8
total: 22806
: 
Audio: 
M4A: 12
MP3: 26
WAV: 31728
WMA: 2
total: 31768
: 
Total Items: 468428
Albums: 58821
Tags: 350
: 
Database backend: QSQLITE
Database Path: C:/Files/digiKam db/
Database locale: UTF-8

STEPS TO REPRODUCE
1. Open digiKam
2. Wait 5+ minutes
3. 

OBSERVED RESULT


EXPECTED RESULT
That it would load *much* faster. By comparison, Picasa (which I still use), loads same libraries nearly instantaneously. 
That said, digiKam is the *first* piece of software I've found to actually replace Picasa - thank you for all you do!!

SOFTWARE/OS VERSIONS
Windows: 
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
Comment 1 Maik Qualmann 2025-03-27 16:40:28 UTC
Almost 60,000 albums is not a small number, it takes time to load them, see Bug 368468.

Maik
Comment 2 caulier.gilles 2025-04-11 18:14:00 UTC
Hi,

The 8.7.0 pre-release Windows installer from today have been rebuilt from
scratch with Qt 6.8.3, KDE 6.12, OpenCV 4.11 + CUDA support, Exiv2 0.28.5, ExifTool 13.27, ffmpeg 7, all image codecs updated to last version (jxl, avif, heif, aom, etc.).

Please try with this version to see if your problem still reproducible...

https://files.kde.org/digikam/

Thanks in advance
Best regards

Gilles Caulier
Comment 3 Atle Bjanes 2025-04-11 20:25:53 UTC
Loaded in 3 min 10 sec. Almost a 50% improvement!

Thank you and let me know when you have another version to test!

Atle
Comment 4 caulier.gilles 2025-04-11 20:43:05 UTC
Great this mean that we are on the right way...