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

[Andi Clemens]

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).

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