[digiKam-users] Tags manage - performance

marcpalaus at hotmail.com marcpalaus at hotmail.com
Tue Jul 7 20:25:55 BST 2020


I also migrated from Picasa to Digikam a while ago.


Ok, so first of all, version 6.4 is a bit old now, and lots of bugs have 
been fixed in the new 7.0 release (the final version will be released in 
a few days, I think).

The good thing with digikam, is that it respects the previous metadata 
made by other software, but also saves the new metadata into the file or 
sidecar so it's permanent. That means that, moving a tag around a tree 
will trigger writing that change to all pictures that share the tags 
that have been affected by the move/merge. Basically digikam has to read 
and then write each one of the files. So for a large library, it can 
take a while. But the idea is that you have a previous idea of the 
hierarchy you want to implement, and minimize the number of "moves" you 
want to make in the tree. (e.g. I have several "root" tags, the main 
ones being People and Places, so moving a branch of places outside of it 
can affect thousands of pictures).

El 7/7/20 a les 15:52, Cesar Inacio Martins ha escrit:
> Hi,
>
> I'm new to Digikam , using version 6.4.
> I imported my photo library which is ~70k photos.
> I'm using SQLite over an SSD hard disk.
>
> Before Digikam I use the Picasa Desktop to manage my photos where I 
> always keep my organization and tags.
> I also set geotag using a program called geosetter which is very handy 
> to set all the geolocation of my photos (since my camera is old and 
> don't have a GPS embedded into).
> This program set for each photo the tags "geo:lat=#####" and 
> "geo:lon=#####" .
> I have this only in ~5% of my photos, which gives ~8k tags (based into 
> this SQL: select count(*) from tags where name like 'geo:%'; ).
>
> Now I'm trying to organize my tags inside of digicam.
> I don't want to remove theses tags, I want to use the tree set 
> resource for better organization.
> However, at the "Tags Manager" moving theses tags inside of a parent 
> tag (called geotagged) is very, very, very slow.
> Tooks ~3 secs to move each tag inside them.
> I check this monitoring the table TagsTree (with dbeaver sqlclient : 
> select count(*) from TagsTree tt ;).
> I already added an index over this table and Tags table to see if 
> help, but appear to have no effect.
> My guess is the slowness is into the client tree view object where is 
> affecting the update process.
>
> I don't know if affect this, but I have my metadata configuration set 
> to "lazy sync"
>
> Any tips?
>
>


More information about the Digikam-users mailing list