[digikam] [Bug 397110] Time to render filters is too long with MYSQL
https://bugs.kde.org/show_bug.cgi?id=397110 [email protected] changed: What|Removed |Added Version Fixed In||8.1.0 Resolution|WORKSFORME |FIXED -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 397110] Time to render filters is too long with MYSQL
https://bugs.kde.org/show_bug.cgi?id=397110 Dav changed: What|Removed |Added Resolution|--- |WORKSFORME Status|REPORTED|RESOLVED --- Comment #10 from Dav --- Seems ok now, @Gilles, with DK 8 / Ubuntu 22.04 Thanks -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 397110] Time to render filters is too long with MYSQL
https://bugs.kde.org/show_bug.cgi?id=397110 --- Comment #9 from [email protected] --- @Dav, digiKam 8.0.0 is out. This entry still valid with this release ? Best regards Gilles Caulier -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 397110] Time to render filters is too long with MYSQL
https://bugs.kde.org/show_bug.cgi?id=397110 --- Comment #8 from [email protected] --- Hi Dav and happy new year, Can you check if problem remain with digiKam 7.5.0 pre-release bundle available here : https://files.kde.org/digikam/ Thanks in advance Gilles Caulier -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 397110] Time to render filters is too long with MYSQL
https://bugs.kde.org/show_bug.cgi?id=397110 --- Comment #7 from [email protected] --- digiKam 7.0.0 stable release is now published and now available as FlatPak: https://www.digikam.org/news/2020-07-19-7.0.0_release_announcement/ We need a fresh feedback on this file using this version. Thanks in advance Gilles Caulier -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 397110] Time to render filters is too long with MYSQL
https://bugs.kde.org/show_bug.cgi?id=397110 --- Comment #6 from Maik Qualmann --- Git commit 845a33a522e044949852589bf0c35cb577ae90da by Maik Qualmann. Committed on 05/08/2018 at 16:48. Pushed by mqualmann into branch 'master'. check if tags info is already in the cache Related: bug 396086 M +18 -3core/libs/database/item/imageinfo.cpp https://commits.kde.org/digikam/845a33a522e044949852589bf0c35cb577ae90da -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 397110] Time to render filters is too long with MYSQL
https://bugs.kde.org/show_bug.cgi?id=397110 --- Comment #5 from Maik Qualmann --- Git commit a3104006d9047ccc338b7eb3d40a975f7059c0a9 by Maik Qualmann. Committed on 05/08/2018 at 16:34. Pushed by mqualmann into branch 'master'. check if group info is already in the cache Related: bug 396086 M +20 -3core/libs/database/item/imageinfo.cpp https://commits.kde.org/digikam/a3104006d9047ccc338b7eb3d40a975f7059c0a9 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 397110] Time to render filters is too long with MYSQL
https://bugs.kde.org/show_bug.cgi?id=397110 --- Comment #4 from Maik Qualmann --- After a long analysis and debugging, I found the cause for repeatedly executing SQL queries. It is used to determine if there are grouped items. Normally, this information is then also in the ImageInfo cache. But in the ImageFilterModelPreparer the function ImageInfoList::loadGroupImageIds() is called and in this function it is not checked if the information is already in the cache and it is read again from the DB. This with every change of sorting direction and filtering. Therefore, this problem is also relevant to bug 396086. This makes by me about 2 seconds with 2 images in the view. So do not explain the long time in the bug reports. I will fix it though. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 397110] Time to render filters is too long with MYSQL
https://bugs.kde.org/show_bug.cgi?id=397110 --- Comment #3 from Mat --- (In reply to Maik Qualmann from comment #1) > The problem can not be reproduced here. Can you install MariaDB to test? I > think the AppImage uses MariaDB's client libraries internally. Right, > Gilles? Both projects have moved relatively far apart. The thing with the > queries, I look at me yet. > > Maik Hi Maik, I should detailed the kind of filters I applied. Part of my tags tree looks like: Country _ Australia _ Western Australia _ Perth _ Botanic Garden Country _ Australia _ South Australia _ Adelaide Country _ France _ Paris _ Eiffel Tower When I noticed all these queries it was when I selected Australia + and the 5 tags just bellow. Hope it can help. Regards -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 397110] Time to render filters is too long with MYSQL
https://bugs.kde.org/show_bug.cgi?id=397110 [email protected] changed: What|Removed |Added CC||[email protected] --- Comment #2 from [email protected] --- Maik, yes it is. Mariadb is used everywhere to build bundles. Gilles -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 397110] Time to render filters is too long with MYSQL
https://bugs.kde.org/show_bug.cgi?id=397110 Maik Qualmann changed: What|Removed |Added CC||[email protected] --- Comment #1 from Maik Qualmann --- The problem can not be reproduced here. Can you install MariaDB to test? I think the AppImage uses MariaDB's client libraries internally. Right, Gilles? Both projects have moved relatively far apart. The thing with the queries, I look at me yet. Maik -- You are receiving this mail because: You are watching all bug changes.
