Bug 443900 - Mysql is very slow over the internet
Summary: Mysql is very slow over the internet
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Mysql (show other bugs)
Version: 7.1.0
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-10-17 18:47 UTC by frederik.bertling
Modified: 2021-12-15 20:48 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 7.5.0
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description frederik.bertling 2021-10-17 18:47:30 UTC 
Hi,

I've recently changed my digikam databse to mysql to make it accessable on multiple machines. This works well on my lan. However it is very slow accessing my server over wan. The bandwidth is not the bottleneck, so I wonder what I can do to improve speed. Or is the database access just not suitable over wan by design?


STEPS TO REPRODUCE
1. Use digikam with a mysql database accessed over wan

OBSERVED RESULT
Very slow loadings of picture compared to lan connection

EXPECTED RESULT
Compareable speed compared to lan connection when bandwith of wan is high enough.

SOFTWARE/OS VERSIONS
Debian 11 on both the client and the server with digikam 7.1.0

ADDITIONAL INFORMATION
Comment 1 Maik Qualmann 2021-10-17 19:28:42 UTC 
One of the main causes is that the thumbnails are also stored in the database and the amount of data to be transferred is significant. We already have a wish to save the thumbnail database locally so that connections over a slower internet connection will improve.

See also Bug 373479

Maik

*** This bug has been marked as a duplicate of bug 297922 ***
Comment 2 caulier.gilles 2021-12-15 20:48:24 UTC 
Fixed with #297922