How about Senna ? Senna is a fulltext search engine embedded in MySQL 4.0, 4.1, 5.0. http://qwik.jp/senna/

… there exist any other matches which still fulfill the search query because the fulltext engine has on its own made up what… my case to decrease the storage needed (which some other fulltext engines “cheats” with) but in my case that cannot be…, but when it comes to “10 most common words” search the mysql fulltext in boolean mode takes more than 800 seconds on…

…. Regarding the 150k example it was more of how the fulltext engine internally needs to process all those hits specially for… temporary table (otherwise someone should explain to me why mysqls fulltext takes more than 800seconds for this 10 most common word… was way faster than mysqls own fulltext it still took 16 seconds for the “heavy” search) and that is why I started…

… in detail? I’m currently using MyISAM becasue of the fulltext index for two forums. Size is 2 Million records and… Innodb and having an extar fulltext ISAM table. This way normal reads that don’t use FT search could run without slowdown from the normal table … A FT search for Inno would propably the…