Open craigh opened 11 years ago
FULLTEXT search is disabled in v4.0.0 because Doctrine2 doesn't natively support FULLTEXT search. This is because Doctrine2 uses InnoDB and InnoDB doesn't support it.
some ideas to consider: http://stackoverflow.com/questions/17594540/fulltext-search-fields-and-doctrine-2 maybe add the ZendSearch as a Core plugin and then use it in Dizkus.
apparently MySQL 5.6 improves InnoDB and allows for full text. Zikula currently only requires MySQL 5.1
http://www.mysqlperformanceblog.com/2013/02/26/myisam-vs-innodb-full-text-search-in-mysql-5-6-part-1/ http://www.mysqlperformanceblog.com/2013/03/04/innodb-full-text-search-in-mysql-5-6-part-2-the-queries/ http://www.mysqlperformanceblog.com/2013/07/31/innodb-full-text-search-in-mysql-5-6-part-3/
http://stackoverflow.com/questions/7246008/doctrine2-use-fulltext-and-myisam
craigh
commented
11 years ago
FULLTEXT search is disabled in v4.0.0 because Doctrine2 doesn't natively support FULLTEXT search. This is because Doctrine2 uses InnoDB and InnoDB doesn't support it.
some ideas to consider: http://stackoverflow.com/questions/17594540/fulltext-search-fields-and-doctrine-2 maybe add the ZendSearch as a Core plugin and then use it in Dizkus.
apparently MySQL 5.6 improves InnoDB and allows for full text. Zikula currently only requires MySQL 5.1
http://www.mysqlperformanceblog.com/2013/02/26/myisam-vs-innodb-full-text-search-in-mysql-5-6-part-1/ http://www.mysqlperformanceblog.com/2013/03/04/innodb-full-text-search-in-mysql-5-6-part-2-the-queries/ http://www.mysqlperformanceblog.com/2013/07/31/innodb-full-text-search-in-mysql-5-6-part-3/