tsuuhou

reading this post and following the links there you get a nice tool for fulltext searches in mysq;  sphinx

try looking at the benchmark – it’s quite impressive.

ibm has an article on building php based searchengines with sphinx