MySQL Forums
Forum List  »  Full-Text Search

Full Text Searching -- is it possible to speed up query with additional where clauses?
Posted by: Joe Aliperti
Date: March 15, 2023 01:54PM

I'm trying to optimize full text queries when I have a particular subset of rows I want to search. But I've noticed that the query times do not improve. Am I doing something wrong:

e.g,

SELECT * FROM `blog_posts`
WHERE `id` IN (1,2,3)
AND MATCH (post_body) AGAINST ('+mango +smoothie' IN BOOLEAN MODE);

takes the same amount of time as:

SELECT * FROM `blog_posts`
WHERE MATCH (post_body) AGAINST ('+mango +smoothie' IN BOOLEAN MODE);

So there doesn't seem to be any time gained from drastically reducing the search pool to a small subset. Is there any way to accomplish a speedup in this case?

I'm using the InnoDB engine, id is the primary key, and there is a full text index on post_body. Thanks for any insight!

Options: ReplyQuote


Subject
Views
Written By
Posted
Full Text Searching -- is it possible to speed up query with additional where clauses?
218
March 15, 2023 01:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.