[digikam] [Bug 473569] New: Horrible performance using Digikam on my Mac with Database on Synology DS 920+

[Martin Neuß]

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-null at kde.org
          Reporter: spamfilter at 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.