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

Maik Qualmann <[email protected]> changed:

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

--- Comment #3 from Maik Qualmann <[email protected]> ---
The first query (where you have add a LIMIT of 10) is used to list the face
tags. There is currently no optimization option here. You have activated the
recursive listing of tags, which costs additional time since the TagsTree is
also included.
We could just disable the view refresh when multiple face tags are confirmed to
speed it up. But that would have other side effects.

The second query, I think, will be significantly accelerated, it is used to
remove the thumbnail if the face tags are no longer available.

And yes, SQLite on a local SSD is significantly faster than MySQL. Only an
internal MySQL on SSD connected via a socket is then faster than SQLite.

Maik

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

Reply via email to