https://bugs.kde.org/show_bug.cgi?id=473569
Bug ID: 473569
Summary: Horrible performance using Digikam on my Mac with
Database on Synology DS 920+
Classification: Applications
Product: digikam
Version: 8.1.0
Platform: macOS (DMG)
OS: macOS
Status: REPORTED
Severity: wishlist
Priority: NOR
Component: Database-Mysql
Assignee: digikam-bugs-n...@kde.org
Reporter: spamfil...@mneuss.de
Target Milestone: ---
Created attachment 161075
--> https://bugs.kde.org/attachment.cgi?id=161075&action=edit
Screenshots recommendations
Hi
I´m using digikam since a few years, with its multitude of functions it is a
very good management tool.
but the performance of the system placing the files on a synology ds 920+ (with
ssd cache), using the synology mariadb database and a 1GB LAN connection is
simply terrible.
and this when i see that network transfers are miniuscule, the load of the nas
cpu is at about 7%, the write transfers on the nas are well below saturation
and the load on my macbookpro m2 (2023) is at about 10%.
setting new keywords for 500 pictures in the database takes minutes and this
when dfirect transfer to the files is disabled so there should be only
database transfers.
- i already adjusted database settings to optimise database storage, caches and
so on.
when checking the recommendations of the mariadb-server there were some
suggestions mostly regarding file indexing and using indices when using "JOIN"
and so on.
i took some screen shots.
- too many joins without using indices (3/minute when less than 1/hour is
typical)
- too often first index table entry is read (27/h when less than 1/h is
typical)
- rate of reading of fixed positions too high (3.4 / second when less than 1/h
is typical)
all those problems are related to missing indices.
so my question is:
is there any way to improve database performance over a LAN-connection as the
actual implementation seems to be very problematic by design.
with best regards
martin
--
You are receiving this mail because:
You are watching all bug changes.
