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

Maik Qualmann <metzping...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |metzping...@gmail.com

--- Comment #3 from Maik Qualmann <metzping...@gmail.com> ---
I see a big difference in the syntax between SQLite and MySQL when using MATCH.
MYSQL requires a FULLTEXT index for the table columns, and SQLite requires FTS5
tables. If I see it correctly, MATCH does not really find parts within a word,
although there is the * wildcard, but the search is only from the beginning of
the word. I can not imagine that the search takes minutes. I have about 50k
images here, a search takes about 1 second. The problem is more because when a
lot of images have been found, it takes a little while until the icon model is
loaded. Please install DebugView from Microsoft. How long does it take to enter
the search text until you see "digikam.database: Search result: XXXX" in the
log?

Maik

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

Reply via email to