Since InnoDB can't full text index BLOB or TEXT, is it a bad idea to use it for the main content table in my system (assuming that I will want a search engine)? Does anyone have experience with the performance of text queries on InnoDB tables?
The alternative would be to run a higher-level indexer or spider in a different "thread", feeding into a separate keyword table. Are there any open-source projects that do this well for MySql?
Thanks,
Eliot
The alternative would be to run a higher-level indexer or spider in a different "thread", feeding into a separate keyword table. Are there any open-source projects that do this well for MySql?
Thanks,
Eliot