[Digikam-devel] extragear/graphics/digikam/digikam

[Gilles Caulier]

2009/6/12 Andi Clemens <andi.clemens at gmx.net>:
> If we keep the thumb db method, we should consider using a SQL query when
> using the scan mode in rebuild thumbs dialog.
> Right now it loads every thumbnail to see if it exists. This was necessary
> with the old freedesktop way, but with a db it is not (I guess).
>
> We could simply query for missing thumbs with SQL and speed up this baby.
> With my 50.000 images collection, full thumbs rebuild takes up to 34min.
> The scan method also takes 16min, because every thumb is loaded, even if it
> doesn't have to, With a query we could really speed this up (like in the
> fingerprints dialog).

I'm totally agree. This is another advantage to use a DB here.

Gilles

>
> Andi
>
> On Friday 12 June 2009 09:02:53 Gilles Caulier wrote:
>> First feedback to compare freedesktop method based on PNG and Thumb DB
>> based on PGF.
>>
>> Here, i use Tools/Rebuild thumbnails/All dialog. See below the results :
>>
>> Computer : PIV 3Ghz, 1.5MB ram.
>>
>> Collections :
>>
>> digiKam version 1.0.0-beta2 (rev.: 979154)
>> JP2k: 21
>> JPG: 1818
>> MOV: 3
>> PNG: 363
>> PPM: 3
>> RAW-CR2: 8
>> RAW-CRW: 9
>> RAW-DNG: 1
>> RAW-MRW: 150
>> RAW-NEF: 9
>> RAW-ORF: 2
>> RAW-RAF: 2
>> RAW-RAW: 1
>> RAW-RW2: 1
>> RAW-X3F: 1
>> TIFF: 82
>> WMF: 1
>> XCF: 3
>> Total Items: 2478
>>
>> * Freedesktop method :
>> -----------------------------
>>
>> rebuild time duration : 16mn 23s
>> cache size :
>>
>> [gilles .thumbnails]$ pwd
>> /home/gilles/.thumbnails
>> [gilles .thumbnails]$ du
>> 189M    ./large
>> 0       ./normal
>> 189M    .
>> [gilles .thumbnails]$
>>
>> * Thumbs database method :
>> -----------------------------------
>>
>> rebuild time duration : 12mn 01s
>> database file size :
>>
>> [gilles at pc-caulier photos]$ pwd
>> /mnt/data/photos
>> [gilles at pc-caulier photos]$ ls -al *.db
>> -rw-r--r-- 1 gilles gilles  1398784 2009-06-12 08:46 digikam4.db
>> -rw-r--r-- 1 gilles gilles 55004160 2009-06-12 08:59 thumbnails-digikam.db
>> [gilles at pc-caulier photos]$
>>
>> Gilles Caulier
>> _______________________________________________
>> Digikam-devel mailing list
>> Digikam-devel at kde.org
>> https://mail.kde.org/mailman/listinfo/digikam-devel
>
> _______________________________________________
> Digikam-devel mailing list
> Digikam-devel at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-devel
>