[Bug 261521] New: a creation or a deletion, of a tag, takes a very long time

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

           Summary: a creation or a deletion, of a tag, takes a very long
                    time
           Product: digikam
           Version: 1.6.0
          Platform: Fedora RPMs
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Tags
        AssignedTo: [hidden email]
        ReportedBy: [hidden email]


Version:           1.6.0 (using KDE 4.5.4)
OS:                Linux

a creation or a deletion, of a tag, takes a very long time if more than 500
tags is present

Reproducible: Always

Steps to Reproduce:
Create a tag tree with more 500 items.

Actual Results:  
> 5 minutes to create or delete a tag


MySQl is used for database

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- 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=261521


Gilles Caulier <[hidden email]> changed:

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




--- Comment #1 from Gilles Caulier <caulier gilles gmail com>  2010-12-29 11:21:28 ---
Give us you DB config from digiKam setup panel.

Do you have the same problem about Rating ?

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- 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=261521





--- Comment #2 from Olivier PIFFAUT <opiffautpro free fr>  2010-12-30 09:13:54 ---
My connection configuration is on localhost with default port (3306) with user
digikam.
The version of mysql in 5.1. digikam user has all right on digikam and
digikamthumbnail databases.

I found the problem.
When digikam create or delete a tag in "tags" table, digikam can update twice
all line of "tags" table. And for each line, the move_tagstree trigger was
launch.
This trigger delete all lines in "tagstree" table (DELETE FROM TAGSTREE;) and
insert new lines (REPLACE ...).
There are 2n (with n is the number lines in tags table, in my case n=745)
DELETE and 2n REPLACE in a transaction but only the last delete and the last
REPLACE are necessaries.

If i delete this trigger, i have a very good response time.
I want to propose a patch in the next month (if i have time to do this)

Regards

Olivier PIFFAUT

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- 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=261521


Marcel Wiesweg <[hidden email]> changed:

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




--- Comment #3 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-12-30 16:47:47 ---
CC'ing Holger.
I'm not familiar with these MySQL triggers (solved differently for SQLite)

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- 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=261521





--- Comment #4 from Quallenauge <Hamsi2k freenet de>  2010-12-31 13:15:10 ---
Hi Olivier,

thanks for your investigation of the problem. I can reproduce the problem in
theory and I'm fine with a patch from you which deletes the trigger and
to move the trigger logic to the responsible function when moving a tag to
another position within the tag tree.

:)

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- 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

[Francesco Riosa-2]

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


Francesco Riosa <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |[hidden email]
         Resolution|                            |FIXED




--- Comment #5 from Francesco Riosa <francesco+kde pnpitalia it>  2011-06-28 19:42:54 ---
fixed in 2.0.0-rc

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- 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=261521

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |2.0.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

[bugzilla_noreply]

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

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Database                    |Database-Mysql

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