[digiKam-users] migrating to internal MySQL

leoutation at gmx.fr leoutation at gmx.fr
Sun Jul 8 14:01:16 BST 2018


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.




More information about the Digikam-users mailing list