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
Philipp

Options: ReplyQuote


Subject
Views
Written By
Posted
Full-text search slower than like
7130
December 11, 2009 12:42PM
2866
February 07, 2010 02:04PM
2698
February 07, 2010 06:14PM
2833
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.