https://bugs.kde.org/show_bug.cgi?id=438253
Bug ID: 438253
Summary: Deleting a large number of tags takes much more than
24h
Product: digikam
Version: 7.2.0
Platform: Microsoft Windows
OS: Microsoft Windows
Status: REPORTED
Severity: major
Priority: NOR
Component: Tags-Manager
Assignee: digikam-bugs-n...@kde.org
Reporter: kai.hackenb...@gmx.net
Target Milestone: ---
SUMMARY
I want to delete ca. 70,000 tags from the database (not from the images)
ca. 90,000 photos are in the database.
ca. 80,000 tags are in the database table tags.
ca. 80,000 tags are in the database table tagstree.
STEPS TO REPRODUCE
1. Start Tag Manager and select ca. 70,000 tags from the list of tags
2. right click on the selected tags and click "Delete"
OBSERVED RESULT
after 24 hours the process is still running and the application is not
responding.
In the database table I see about 4 deletions per minute
EXPECTED RESULT
the deletion process should finish within a minute
SOFTWARE/OS VERSIONS
Windows: 10
ADDITIONAL INFORMATION
The database engine is MySQL
The database as well as the photos are hosted on a fast performing SSD.
The CPU has 6 cores (12 with HT)
RAM is 32 GB
My GUESS:
The database uses a trigger on deletion in table tags, which removes the
related entries from table tagtree. I am no DB expert, but this trigger seems
heavy if executed for each deletion of one of the 70,000 to be deleted tags.
My Proposal:
Can you please send me a DELETE/JOIN statement that I could execute on the
directly against the database instead of using Tag Manager.
--
You are receiving this mail because:
You are watching all bug changes.
