https://bugs.kde.org/show_bug.cgi?id=524265
Bug ID: 524265
Summary: Delay when selecting a tag with "Include Tag Sub-Tree"
enabled [patch]
Classification: Applications
Product: digikam
Version First 9.1.0
Reported In:
Platform: Compiled Sources
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: Database-Engine
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 195158
--> https://bugs.kde.org/attachment.cgi?id=195158&action=edit
Proposed patch
DESCRIPTION
There is a noticeable delay when selecting a tag in the sidebar when "Include
Tag Sub-Tree" is enabled.
STEPS TO REPRODUCE
1. In the menu bar, enable "View" -> "Include Tag Sub-Tree".
2. Click "Tags" on the left sidebar.
3. Select any Tag.
OBSERVED RESULT
A 3 seconds delay before the images are displayed.
EXPECTED RESULT
Images are displayed immediately upon selecting a tag.
SOFTWARE/OS VERSIONS
Operating System: openSUSE Tumbleweed-Slowroll 20260601
KDE Plasma Version: 6.6.5
KDE Frameworks Version: 6.26.0
Qt Version: 6.11.1
PROPOSED SOLUTION
Modify the `listTagRecursive` query to use `EXISTS` instead of `SELECT
DISTINCT` and `IN` to prevent the database from generating duplicate rows that
require sorting.
After applying the proposed patch, delay is down to 0.5 second
Patch tested with mariadb 12
--
You are receiving this mail because:
You are watching all bug changes.
