MySQL Forums
Forum List  »  Full-Text Search

Full-text search slower than like
Posted by: Philipp Prelicz
Date: December 11, 2009 12:42PM

Hello everybody,

When I use full-test search it is about 50 times slower than like!

My statement looks like this:
Select t1.Col1, t3.Col3
from table1 t1 inner join table2 t2 on (t1.ID= t2.ID)
inner join table3 t3 on (t2.ID2 = t3.ID)
where match (t1.Col1) against ('xyz*' in boolean mode) and match (t3.Col3) against ('abc*' in boolean mode)

Each t1.Col1 and t3.Col3 have a full-text index.
Explain shows that the all the indexes are used correctly.

Statement needs about 6 Seconds - with like '%xyz%' instead of match-against needs about 0.2 Seconds.

I would appreciate any suggestens about what could be wrong.

best regards

Options: ReplyQuote

Written By
Full-text search slower than like
December 11, 2009 12:42PM
February 07, 2010 02:04PM
February 07, 2010 06:14PM
February 10, 2010 08:26PM

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.