[digiKam-users] dk6b3 searches

[leoutation at gmx.fr]

On 11/6/18 11:49 PM, digikam at 911networks.com wrote:
> 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...
> 
Above, I wrote
 >> Mariadb external server (on localhost) because it's faster than
 >> sqlite.
You have to test yourself :)