MySQL Forums
Forum List  »  Full-Text Search

Help optimizing Fulltext query
Posted by: Andrew Brosnan
Date: August 30, 2005 02:36PM

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 terms.
'articles' table has about 100,000 records.

The query runs OK (< 0.1 sec) as long as 'S' is small (< 10 terms), but as the number of terms increase, it bogs down big-time.

EXPLAIN says:
*************************** 1. row ***************************
table: articles
type: fulltext
possible_keys: art_ft
key: art_ft
key_len: 0
ref:
rows: 1
Extra: Using where
1 row in set (0.00 sec)

Any suggestions?

Options: ReplyQuote


Subject
Views
Written By
Posted
Help optimizing Fulltext query
3197
August 30, 2005 02:36PM
2166
August 31, 2005 07:12PM


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.