[digiKam-users] Anyone with a +300K photos internal mysql database?

[Dumelle, Timo (E+K)]

I am dropping in here.

I have 305k photos in many folders on a network share.
Many of the folders on that share don't contain pictures, but since the paths are kinda "mixed up" with other files I can't just scan the photos.

Dk needs about 5 - 10 minutes to start up while hanging on "reading database"
And nearly every operation that goes beyond just viewing pics in albums cause it to either not responding for a long time or crashing
Currently it is finding duplicates which seems to proceed pretty fast.

Picasa for example has absolute no problems with this pictures. 
But I need server functions for about 20 clients to connect to the DB

Can I help with any of these tests?

-----Ursprüngliche Nachricht-----
Von: Digikam-users <digikam-users-bounces at kde.org> Im Auftrag von Rafael Linux
Gesendet: Freitag, 24. August 2018 00:54
An: digikam-users at kde.org
Betreff: Re: [digiKam-users] Anyone with a +300K photos internal mysql database?

Maik, as I wrote to Gilles, I can't see how many folders cause the user is on holidays this week, and I have no access to it, but I estimate that could be
+13k albums, mostly with JPG photos.

I want to thank you your test, cause I was sure that the reason of the issues weren't in the hardware or the database (mysql process never fired up any CPU core).

If I can help anyway, let me know, but take into account that I can't do any test in any moment, cause the real system is not mine, so I have not access to it at my own  



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html