[digikam] [Bug 376891] Digikam becomes unusable with many Metatags

[bugzilla_noreply at kde.org]

https://bugs.kde.org/show_bug.cgi?id=376891

--- Comment #7 from bzrudie at protonmail.ch ---
Okay Gilles, did some more testing.
Started from scratch and sadly no change, problem exists. So I checked database
and started to simply delete some tags from the Tags relation. E.g. as i have
more than 5000 tags I started with:

sqlite> delete from Tags where id > 4500;
no real change...
sqlite> delete from Tags where id > 4000;
no real change...
sqlite> delete from Tags where id > 3000;
better, tag manager now starts within 7 seconds...
sqlite> delete from Tags where id > 1000;
nice, tag manager starts within 1-2 seconds. I would say things work within an
acceptable time.
going even further and just leave 500 tags within database things rock!

===
- Startup time digikam: 5000+ tags 3min 20 seconds vs. 500 tags 13 seconds!
- Startup time "Open Tag Manager": 5000+ 23 seconds vs. 500 tags 1 second!
- Click on "+" to add a new tag: 5000+ 5 seconds vs. 500 tags realtime
- Entering a new tag in that window and click save makes digikam become
unresponsive for 1min and 33 seconds, doh! vs. 500 tags 2 seconds
- Deleting the newly created tag takes nearly the same time, 1min and 36s vs.
500 tags 2 seconds
===


So things get massiv slower when reaching 2000 or 3000 tags. Feels some indexes
are missing!? Maybe I have the time tomorrow for testing out.

cheers bzrudi

-- 
You are receiving this mail because:
You are the assignee for the bug.