[digiKam-users] dk6b3 searches

[digikam at 911networks.com]

On Tue, 6 Nov 2018 23:19:10 +0100
leoutation at gmx.fr wrote:

> On 11/6/18 9:33 PM, digikam at 911networks.com wrote:
> > I don't know if searching by date would be faster, I never
> > use the sort by date because of my naming conventions:
> > text-yyyymmdd-counter_from_camera.ext, so it's already sorted by
> > name & date.
> > 
> > To me, it looks like the slowdown/speed is due to the thumbnail
> > previews. The files are there but then DK takes a while to
> > display them.
> > 
> > I have 50000 images (no video), is it worthwhile to convert to
> > mysql/mariadb? How much faster would it be?  
> 
> Thumbnails creation speed depends on hardisk performances. I use
> Mariadb external server (on localhost) because it's faster than
> sqlite. You have to know that migrating from sqlite to mariadb will
> take a long time, many, many hours. It depends on your hardware.

I don't mind the time for the creation the thumbnails, it's one time
only per ingestion.

What I was asking (not very clearly: English is not my first, nor
second language), is if when I have 50000 images and no video, will
mysql/mariadb be the same speed (as sqlite) or faster or much faster
during the regular browsing, searching...

Thanks

Syv

-- 
sknahT

vyS