[digiKam-users] migrating to internal MySQL

[Pioter Gmoter]

So stability is ok. What about speed? Any noticeable difference? My DK 
is blocking too much when starting, importing photos etc. I wonder about 
mysql behavior here.

P.



W dniu 08.07.2018 o 15:01, leoutation at gmx.fr pisze:
> 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.
>