https://bugs.kde.org/show_bug.cgi?id=440951
Halla Rempt <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Latest Commit| |https://invent.kde.org/grap | |hics/krita/commit/1fb0eb8ce | |1d94869a6ebdf87e83e53081f30 | |3914 Status|ASSIGNED |RESOLVED Resolution|--- |FIXED --- Comment #3 from Halla Rempt <[email protected]> --- Git commit 1fb0eb8ce1d94869a6ebdf87e83e53081f303914 by Halla Rempt, on behalf of Mathias Wein. Committed on 16/08/2021 at 08:20. Pushed by rempt into branch 'master'. Don't search for occurrence of empty strings in resourceExists() For filename there exists an automatic index due to the table condition: UNIQUE("storage_id","resource_type_id","filename") so the search is fast, and should solve Bug 440951. But the search for md5 is about 2 orders of magnitude on a resource collection with a few additional packs. It's not clear yet why searching for name isn't nearly as slow, despite also lacking an (auto-)index, according to the "EXPLAIN QUERY PLAN" output. M +50 -40 libs/resources/KisResourceModel.cpp https://invent.kde.org/graphics/krita/commit/1fb0eb8ce1d94869a6ebdf87e83e53081f303914 -- You are receiving this mail because: You are watching all bug changes.
