100 search items is a lot to search on at once for any system. MySQL
has to search on a 100 terms, no way around that.
I think the only way to optimize your query is to narrow down the
search terms. Perhaps you can search on phrases instead of words?
After the first 5-10 terms have been matc
Hello,
I need some help optimizing a query. The current query is as follows:
SELECT *,
MATCH(title) AGAINST ( 'S' IN BOOLEAN MODE ) AS score
FROM articles
WHERE MATCH(title) AGAINST ( 'S' IN BOOLEAN MODE );
'title' is a FULLTEXT index.
'S' is a query string that may have 100 search term