[digiKam-users] Tags manage - performance

[Cesar Inacio Martins]

If I close the DK application and update the table tags and insert manually
into tagstree, will work?
Since there is no trigger to update tags only I think I will need to
manually create the record into tagstree table.

I'm pretty sure that is not recommendable but this behavior is very
annoying and it took too long.




Em ter., 7 de jul. de 2020 às 10:52, Cesar Inacio Martins <
cesar.inacio.martins at gmail.com> escreveu:

> 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/0dd43fb3/attachment-0001.htm>