[digiKam-users] Tags manage - performance

[Cesar Inacio Martins]

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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20200707/4cc54d37/attachment.htm>