Looks like only question and answer tables need fulltext index, which is not supported by InnoDB. What if I'm going to use a search engine for search of questions and answers anyway, can I not apply Migration 4 and use InnoDB? I have a lot of other tables in InnoDB and really don't want to fall back to MyISAM.
@Evengy, it would be great, if you have any documentation/article to say how we can configure haystack with askbot, it will be big+ for user like who prefer solr over sphinx.
Thanks, N.
As of version 0.6.86, it is possible, but still InnoDB does not support text search properly.
To completely fix this issue, we'll need to support some external search library, such as solr, sphinx, etc.
At the moment, with askbot the best options are either transition your other app to PostgresQL or with a quick fix on our part - accept loss of text search support - until we work with a specialized search library. (e.g. Django Haystack)
Comments