<html dir="ltr"><head></head><body style="text-align:left; direction:ltr;" bgcolor="#ffffff" text="#2e3436" link="#2a76c6" vlink="#2e3436"><div>I have found that the majority of the startup time is spent reading the similarity database.</div><div><br></div><div>Startup takes about 8 minutes on a image collection of about 400K images. Most of the time is spent on the query "SELECT value FROM ImageSimilarity WHERE ( imageid1=? OR imageid2=? ) AND algorithm=? ..." (I don't have any of the query after the ?. Sorry)</div><div><br></div><div>Nothing is logged to the console while reading the database.If I replace the similarity database with a blank one, startup is reduced to about 34 seconds.</div><div><br></div><div>If I re-build the database, start up times are again slow.</div><div><br></div><div>This is running DK6 Beta2 Oct 15 release.</div><div><br></div><div><br></div><div>Rob</div><div><br></div><div><br></div><div><br></div><div>On Fri, 2018-10-19 at 08:22 +0000, Dumelle, Timo (E+K) wrote:</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><pre>I am dropping in here.</pre><pre><br></pre><pre>I have 305k photos in many folders on a network share.</pre><pre>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.</pre><pre><br></pre><pre>Dk needs about 5 - 10 minutes to start up while hanging on "reading database"</pre><pre>And nearly every operation that goes beyond just viewing pics in albums cause it to either not responding for a long time or crashing</pre><pre>Currently it is finding duplicates which seems to proceed pretty fast.</pre><pre><br></pre><pre>Picasa for example has absolute no problems with this pictures. </pre><pre>But I need server functions for about 20 clients to connect to the DB</pre><pre><br></pre><pre>Can I help with any of these tests?</pre><pre><br></pre><pre>-----Ursprüngliche Nachricht-----</pre><pre>Von: Digikam-users <</pre><a href="mailto:digikam-users-bounces@kde.org"><pre>digikam-users-bounces@kde.org</pre></a><pre>> Im Auftrag von Rafael Linux</pre><pre>Gesendet: Freitag, 24. August 2018 00:54</pre><pre>An: </pre><a href="mailto:digikam-users@kde.org"><pre>digikam-users@kde.org</pre></a><pre><br></pre><pre>Betreff: Re: [digiKam-users] Anyone with a +300K photos internal mysql database?</pre><pre><br></pre><pre>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</pre><pre>+13k albums, mostly with JPG photos.</pre><pre><br></pre><pre>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).</pre><pre><br></pre><pre>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 </pre><pre><br></pre><pre><br></pre><pre><br></pre><pre>--</pre><pre>Sent from: </pre><a href="http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html"><pre>http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html</pre></a><pre><br></pre></blockquote></body></html>