[digikam] [Bug 315574] New: Bad performace when Tag-related Sidebars (Tag management / Filter) are open

[Lemke]

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

            Bug ID: 315574
           Summary: Bad performace when Tag-related Sidebars (Tag
                    management / Filter) are open
    Classification: Unclassified
           Product: digikam
           Version: 3.0.0
          Platform: Other
                OS: Linux
            Status: UNCONFIRMED
          Severity: major
          Priority: NOR
         Component: general
          Assignee: [hidden email]
          Reporter: [hidden email]

DigiKam becomes very slow and doesn't react fluently on
mouse clicks, if a sidebar related to Tags is opened (filter or management).
When selecting a Tag or opening a Tag-tree, a delay of 3-5 seconds happens.

It also seems to me, that the whole client slows down.

Reproducible: Always

Steps to Reproduce:
1. Open Sidebar related to Tags
2. Try to select Tag (to filter with or to assign)
Actual Results:  
Delay of at least 3-5 seconds until reaction of client (visual feedback,
checkbox is selcted).

Expected Results:  
Less delay, even with opened tag related sidebar.

I am running DigiKam 3.0.0 with the MySql-Backend.
My Tag-Structure is complex, but not huge (about 30 Tags in different
Tag-trees).
I had similar problems with DigiKam 2.8 - but less severe.

For me, the Tag feature is not useable at the moment.

Do not hesitate to contact me for further information.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Lemke]

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

Lemke <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           See Also|                            |https://bugs.kde.org/show_b
                   |                            |ug.cgi?id=124688

--- Comment #1 from Lemke <[hidden email]> ---
I was able to improve performance by removing all icons from my Tag tree.

Maybe related to https://bugs.kde.org/show_bug.cgi?id=124688?

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Lemke]

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

--- Comment #2 from Lemke <[hidden email]> ---
When starting DigiKam, I got the following Messages within the console:

QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in
use, all queries will cease to work.
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Need Tagging History Graph"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Need Resolving History"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Color Label None"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Color Label Red"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Color Label Orange"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Color Label Yellow"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Color Label Green"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Color Label Blue"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Color Label Magenta"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Color Label Gray"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Color Label Black"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Color Label White"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Pick Label None"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Pick Label Rejected"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Pick Label Pending"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Pick Label Accepted"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Original Version"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Intermediate Version"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Current Version"  with pid  64
digikam(6817)/digikam (core) Digikam::AlbumManager::scanTAlbums: Failed to find
parent tag for tag  "Unbekannt"  with pid  95

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]
          Component|general                     |Database

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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

--- Comment #3 from Marcel Wiesweg <[hidden email]> ---
Is the performance merely better, or is the problem gone when removing icons?

The error messages indicate a problem; The parent tag of the listed, internal
tags needs to be a tag _Digikam_Internal_Tags_ which itself needs to have no
parent.
Do pick and color labels work for you?

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Lemke]

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

--- Comment #4 from Lemke <[hidden email]> ---
Created attachment 77551
  --> https://bugs.kde.org/attachment.cgi?id=77551&action=edit
Difference between db-dumps with bad and good performance

I created two database dumps:
- The first one (mysql_dump_130221.sql) causes the bad performance issue.
- The second one (mysql_dump_130223.sql; based on the first dump) contains a
slightly modified tag structure and improves the performance. It is possible to
work fluently with this database and the performance is very good.

The diff contains the tag-related differences of these two dumps described
above.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Lemke]

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

--- Comment #5 from Lemke <[hidden email]> ---
Yes, color labels and pick work for me with both new and old tag structure.

Some more background information:
I created two database dumps:
- The first one causes the bad performance issue.
- The second one (based on the first dump) contains a slightly modified tag
structure and improves the performance. It is possible to work fluently with
this database and the performance is very good.

But:
I get the posted error messages with both database dumps - so it seems to me,
that theese messages are not related to the performance issue.

I attached a diff of the two database dumps to this bug report.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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

--- Comment #6 from Marcel Wiesweg <[hidden email]> ---
The diff is not really a diff because it's all in a single line, which differs
then.
What has actually been changed?

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Lemke]

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

--- Comment #7 from Lemke <[hidden email]> ---
Created attachment 77570
  --> https://bugs.kde.org/attachment.cgi?id=77570&action=edit
Reformatted Diff

The first attachment was a simple diff of two db dumps - therefore the diff
seems to be senseless at first glance...  

I reformatted my posted diff result a little bit and applied another diff to
make the low level differences more clearly.

The changes I made knowingly:
I removed the icons from some of the tags and renamed a tag - that improved the
performance for me.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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

--- Comment #8 from Marcel Wiesweg <[hidden email]> ---
Ok, as far as I see the only difference really is in the icons. Mostly
"gnome-control-center" and a few other icons have been removed. That directs us
back to the icons being at the root of the problem. I suspect some problem with
kdelibs taking a long time to load icons, maybe not existing icons or some
other problem.
Is CPU consumed by digikam or another process when the delay occurs?

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Lemke]

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

--- Comment #9 from Lemke <[hidden email]> ---
Yes, there is a significant CPU consumption caused by the digikam process.
It occurs, when the tag filter dialog is opened, and tags are selected /
unselected.

In this case, the digikam process occupies 25% on my 4-core CPU (KDE system
monitor)- "top" shows up to 100% - so it seems to me that the digikam process
is using a core completely.

After the delay, the cpu utilisation falls to aprox. 0 %.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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

--- Comment #10 from Marcel Wiesweg <[hidden email]> ---
Just one more step: To prove that the icons are the problem, please take your
"normal working" database, assign "gnome-control-center" to three or four tags,
and check if the delay reappears then.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Lemke]

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

--- Comment #11 from Lemke <[hidden email]> ---
Maybe we found the cause of my problem:
I was not able to assign "gnome-control-center" to some of my tags - I was not
able to find that icon within the dialog anymore.... I also tried a filesystem
search - no results...

But I cannot remember missing icons within the gui in the past - is there a
cache-mechanism implemented which buffers the displayed icon without the
physical file?
Maybe the delay was caused by timeouts reading the (missing) icons from
filesystem....

Cross Check:
I assigned 4 different (existing) icons to some tags - to impact on performace.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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

--- Comment #12 from Marcel Wiesweg <[hidden email]> ---
We use KDE libraries to load these system icons. Either there's a KDE bug
causing these repeated delays (not caching the "not found" result) or we use
methods synchronously which should be called asynchronously.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

--- Comment #13 from Gilles Caulier <[hidden email]> ---
As Marcel said in comment #12, a bug is present in KDELibs.

Which KDELibs do you use ?

Do you try to use digiKam in this context with a more recent KDE version ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Bad performace when         |Bad performance when
                   |Tag-related Sidebars (Tag   |Tag-related Sidebars (Tag
                   |management / Filter) are    |management / Filter) are
                   |open                        |open

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

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

--- Comment #14 from Kristian <[hidden email]> ---
Could be related or duplicate of #328124.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Bad performance when        |CORE : Bad performance when
                   |Tag-related Sidebars (Tag   |Tag-related Sidebars (Tag
                   |management / Filter) are    |management / Filter) are
                   |open                        |open

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|CORE : Bad performance when |CORE : bad performance when
                   |Tag-related Sidebars (Tag   |Tag-related Sidebars (Tag
                   |management / Filter) are    |management / Filter) are
                   |open                        |open

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #15 from Gilles Caulier <[hidden email]> ---
*** Bug 339720 has been marked as a duplicate of this bug. ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel