Hiah... yes, I have fulltext indexing on the body of my posts. This resulted in very significant performance enhancement when using "OR" searches in 5.5 ... the "OR" search was blazingly fast, and I made it the default on the search page at the time.
However, as I just upgraded to 6.02, I'm noticing that the fully indexed "OR" search seems to be significantly slower than the stock "entire phrase" search (which can't take advantage of the indexing anyway). I haven't done much testing yet though. But at first glance, I don't think it's really worth it for most users to do a fulltext index right now.
But I'm not running mysql 4.01 , so if you are, you might want to give it a shot... 4.01 can take advantage of fulltext indexing with "AND" searches as well.
Regards,
Max
