Bug 443900

Summary:	Mysql is very slow over the internet
Product:	[Applications] digikam	Reporter:	frederik.bertling
Component:	Database-Mysql	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	RESOLVED FIXED
Severity:	normal	CC:	caulier.gilles, metzpinguin
Priority:	NOR
Version First Reported In:	7.1.0
Target Milestone:	---
Platform:	Other
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:	7.5.0
Sentry Crash Report:

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