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

[Gilles Caulier]

2015-11-12 12:43 GMT+01:00 maderios <maderios at gmail.com>:

> On 11/12/2015 11:18 AM, Pedro Neves wrote:
>
> I'm not an expert on databases or MySQL, but the explanation Gilles gave
>> makes sense to me. I'm using SQlite and to me, it makes sense to only
>> use MySQL as a remote storage.
>> But that's only my opinion...
>>
> Hi
> My experience: mysql is much better because it runs faster than sqlite,
> especially  with huge images stock, > 20 000 or 30 000. In this last case,
> Sqlite takes hours to rebuild db.


yes, i agree. In fact 2 user cases :

databases are local : sqlite : enough for small and medium collections.
databases are remote : mysql : for large collections.

Note that i use more than 100.000 items in my collections, hosted in a huge
SDD (including sqlite databases files), and this work perfectly.

Gilles


>
>
> --
> Maderios
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20151112/6774a107/attachment.html>