[digiKam-users] migrating to internal MySQL

[Gilles Caulier]

It's an error from the documentation. The right threshold is 100.000 items.

Here i use 400.000 items with sqlite and a SSD and it's sometime tedious,
but suitable.

Best

Gilles caulier

2018-07-08 15:01 GMT+02:00 <leoutation at gmx.fr>:

> On 07/08/2018 02:00 PM, Pioter Gmoter wrote:
>
>> O the site mentioned below once is said that migrating from SQLite to
>> mysql makes sens '..'when collections include more than 100,000 items'
>> and few lines below 'While using a large collection, of size greater
>> than 10,000 items, the application tends to slow down'
>>
>> So 10 000 or 100 000 is the threshold?
>>
>> I have 40 000 images/video files. Does it makes sense to migrate to
>> internal mysql?
>>
>> Well, mysql is still experimental, so in spite of the reasons above is
>> it safe?
>>
>> Hi
> I have about 20.000 pictures files. Last year, I migrated from sqlite to
> external mysqldb / mariadb, it works fine for me with DK 5.9 and DK git . I
> consider mysql it's stable now, from far much better than sqlite.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20180708/e3ffdbc2/attachment.html>