[Digikam-users] Mysql/MariaDb database expert needs...

Gilles Caulier caulier.gilles at gmail.com
Thu Nov 12 17:19:17 GMT 2015

2015-11-12 17:38 GMT+01:00 Henrique Santos Fernandes <sf.rique at gmail.com>:

>> The one advantage of having separate databases is for backup purposes.
>> The thumbnail database in particular can be massive and having it
>> separate makes it easier especially since it is basically throwaway data
>> anyway.
> This is true. But still easy to remove or drop the tables related to it.
> Only "problem" would be the backup size, as it would include the
> thumbnails..
>> The performance of MySQL doesn't really come into it. You can in theory
>> partition different databases into different locations/disks etc. and
>> that might be of interest to some but it would be a pretty special use
>> case.
>> I think that the correct default would be to use a common name for all
>> three but allow separate names if required.
> I think teh default should be one database also.
> I guess, having the possibility to separate the databases  would introduce
> much more work right? I am not sure.. not a developer..  i only know some
> about infrastructure .

much more work to prepare the databases. Yes. All the rest in digiKam
database interface is ready.

Perhaps there are some point to test in this configuration. We will see...

Gilles Caulier
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20151112/8c7ec1d3/attachment.html>

More information about the Digikam-users mailing list