[digikam] [Bug 524265] New: Delay when selecting a tag with "Include Tag Sub-Tree" enabled [patch]

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.