<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;color:#000066">I've tried both. The photos are on the network share, but I've tried it with a local Sqlite, a local mysql and a remote mysql. The performance is unusable on all of them - 10+ minutes startup before I can start browsing images, etc. And that's with auto-import at startup turned off. </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 29 May 2019 at 13:31, Gilles Caulier <<a href="mailto:caulier.gilles@gmail.com">caulier.gilles@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Across the network, sqlite is not the problem, as you CANNOT store the database on a network file system. It must be in local. Only the collection can be on a remote storage.<div><br></div><div>So the network bandwith usable to consult the collections is the real problem.</div><div><br></div><div>With a remote Mysql, you use more bandwith with the database.</div><div><br></div><div>Gilles Caulier</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mer. 29 mai 2019 à 14:27, Mark Otway <<a href="mailto:mark@otway.com" target="_blank">mark@otway.com</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;color:rgb(0,0,102)">I found both sqlite and mysql were equally slow and painful with a collection of 400k images which are stored across the network. ;)</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 29 May 2019 at 13:02, Gilles Caulier <<a href="mailto:caulier.gilles@gmail.com" target="_blank">caulier.gilles@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi,<div><br></div><div>At home, my collection is over 250.000 files with sqlite. Database and files are stored on SSD and it's enough fast.</div><div><br></div><div>GillesC aulier</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mer. 29 mai 2019 à 12:24, Dougie Nisbet <<a href="mailto:dougie@katsura.uk" target="_blank">dougie@katsura.uk</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF">
<p>Since I'm just starting out with digikam I thought this was the time to experiment with migrating to mysql. On the configuration screen digiKam can find the binary for mysql_install_db but not mysqld. mysqld is installed and when I use 'find' to tell it that the binary is in /usr/sbin/mysqld it looks promising.</p>
<p>However, trying to migrate the database gives the pop-up error window:
</p>
<p style="margin:12px 0px;text-indent:0px">
An error occurred during the internal server start.</p>
<p style="margin:0px;text-indent:0px">Details: Could not start database initialiser.</p>
<p style="margin:12px 0px;text-indent:0px">Executable: mysql_install_db</p>
<p style="margin:12px 0px;text-indent:0px">Arguments: --datadir=/store1/images/.mysql.digikam/db_data, --defaults-file=/tmp/.mount_digikaJbT7bS/usr/share/digikam/database/mysql-global.conf</p>
<p style="margin:12px 0px;text-indent:0px">Process error: Unknown error</p>
<p style="margin:12px 0px;text-indent:0px">and on the command line I see:</p>
<p style="margin:12px 0px;text-indent:0px">Digikam::DatabaseServer::processErrorLog: Arguments: "--datadir=/store1/images/.mysql.digikam/db_data, --defaults-file=/tmp/.mount_digikaJbT7bS/usr/share/digikam/database/mysql-global.conf"
Digikam::DatabaseServer::processErrorLog: Stdout: "Neither host 'office' nor 'localhost' could be looked up with\n'/usr/sbin/resolveip'\nPlease configure the 'hostname' command to return a correct\nhostname.\nIf you want to solve this at a later stage, restart this script\nwith the --force option\n\nThe latest information about mysql_install_db is available at\nhttps://<a href="http://mariadb.com/kb/en/installing-system-tables-mysql_install_db%5Cn" target="_blank">mariadb.com/kb/en/installing-system-tables-mysql_install_db\n</a>"</p>
<p style="margin:12px 0px;text-indent:0px">which is a bit off. resolveip is a command I didn't know existed but running it returns a local IP address for my host.</p>
<p style="margin:12px 0px;text-indent:0px">Performance using sqlite seems ok, and at just over 100k images I'm probably a borderline case so I thought I would try the mysql database option out of curiosity.
</p>
<p style="margin:12px 0px;text-indent:0px">
</p>
<p></p>
</div>
</blockquote></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>