falcon (new mysql engine) will rock on fulltext searches
via Jeremy’s blog
The good news is that the recently announced falcon storage engine should have a FULLTEXT engine that rocks. After explaining the situation a bit more, we decided that in the mean time a 64-bit MySQL with a ton of RAM is probably the only viable solution.
More info about Falcon:
http://www.eweek.com/article2/0,1759,1953658,00.asp?kc=EWRSS03129TX1K0000608