[digikam] [Bug 341111] MYSQL : deleting an image involves "too many" queries

[Maik Qualmann]

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

Maik Qualmann  changed:

   What|Removed |Added

   Version Fixed In||7.0.0
 Status|REPORTED|RESOLVED
 CC||metzping...@gmail.com
 Resolution|--- |FIXED

--- Comment #12 from Maik Qualmann  ---
This bug was fixed by Bug 375317, so I close this bug now.

Maik

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 341111] MYSQL : deleting an image involves "too many" queries

[bugzilla_noreply]

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

--- Comment #11 from caulier.gil...@gmail.com ---
What's about this file using digiKam AppImage bundle 5.4.0 pre release given at
this url :

https://drive.google.com/drive/folders/0BzeiVr-byqt5Y0tIRWVWelRJenM

Gilles Caulier

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 341111] MYSQL : deleting an image involves "too many" queries

[via KDE Bugzilla]

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

--- Comment #10 from caulier.gil...@gmail.com ---
Swati, Roy,

In theory, 2K of request for 1K of items is logic. To display icon view, for
each item, from the database we need :

1/ the image information as comments, tags, rating, labels, GPS, etc.
2/ the thumbnail.

But, we have the cache between icon view and database.

So, i suspect 2 points :

1/ for obscur reason the cache was broken when the report have been written,
2/ the cache was not enough large for 1K items.

I just tested, and i'm sure that at least, cache for thumbnails work fine (100
items here).

Gilles Caulier

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 341111] MYSQL : deleting an image involves "too many" queries

[Roy Bellingan via KDE Bugzilla]

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

--- Comment #9 from Roy Bellingan  ---
Hy to all!

I think that the expected result is "no query" at all, we already have all the
info of the folder, so why reload ?

At the time of the bug report my programming knowledge was "scarce", but now I
think I can even try to fix this! 

I download now the code and start looking around, do anyone has suggestion on
where to start ?

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 341111] MYSQL : deleting an image involves "too many" queries

[via KDE Bugzilla]

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

--- Comment #8 from swatilodh...@gmail.com ---
Yeah, I got it. You're right about that. 

So what would be the "expected result" in such case, involving thousands  of
images in an album ?

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 341111] MYSQL : deleting an image involves "too many" queries

[via KDE Bugzilla]

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

--- Comment #7 from caulier.gil...@gmail.com ---
Conclusion ?
How many queries send to the server for an item removed from an album with 1K
items ?

Gilles

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 341111] MYSQL : deleting an image involves "too many" queries

[via KDE Bugzilla]

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

--- Comment #5 from swatilodh...@gmail.com ---
Created attachment 100138
  --> https://bugs.kde.org/attachment.cgi?id=100138=edit
Queries in trace

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 341111] MYSQL : deleting an image involves "too many" queries

[via KDE Bugzilla]

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

--- Comment #6 from swatilodh...@gmail.com ---
Yes, I did follow all the steps.

Please find the attachment that includes the queries.

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 341111] MYSQL : deleting an image involves "too many" queries

[via KDE Bugzilla]

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

--- Comment #4 from caulier.gil...@gmail.com ---
Swati,

Are you tried to follow all steps to reproduce described in original post to
trace all queries done while deletion ? How many queries do you see in trace in
this condition ?

Gilles Caulier

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 341111] MYSQL : deleting an image involves "too many" queries

[via KDE Bugzilla]

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

--- Comment #3 from swatilodh...@gmail.com ---
I don't actually find a bug in this condition. I deleted an image and on seeing
the general query log, it included the SQL queries to update the rest of images
in that album. I think this is how it should work.

Could you elaborate "Expected Results:  Just the image I'm going to see is
refreshed."? Since, you've deleted the image, which image are you exactly
talking about?

Thanks.

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 341111] MYSQL : deleting an image involves "too many" queries

[via KDE Bugzilla]

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

caulier.gil...@gmail.com changed:

   What|Removed |Added

 CC||swatilodh...@gmail.com

--- Comment #2 from caulier.gil...@gmail.com ---
Swati,

Do you confirm this file ?

Gilles Caulier

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 341111] MYSQL : deleting an image involves "too many" queries

[via KDE Bugzilla]

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

--- Comment #1 from caulier.gil...@gmail.com ---
This file still valid using last digiKam 5.0.0 ?

Gilles Caulier

-- 
You are receiving this mail because:
You are watching all bug changes.