Full-text search slower than like

[Philipp Prelicz]

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