Deebs
Well-known member
Guys,
MySQL Labs have just released 5.6 (preview/testing only) which includes some pretty nifty enhancements to InnoDB including Full Text Indexing on InnoDB tables.
Thankfully they have decided to use the same Full Text syntax as MyISAM tables so you shouldn't have to change anything to take advantage of their implementation and first impressions look very promising!
http://blogs.innodb.com/wp/2011/07/overview-and-getting-started-with-innodb-fts/
http://blogs.innodb.com/wp/2011/07/innodb-full-text-search-tutorial/
http://blogs.innodb.com/wp/2011/07/innodb-fts-performance/
Hopefully this will allow even better search performance out of the box for XF when officially available as GA.
MySQL Labs have just released 5.6 (preview/testing only) which includes some pretty nifty enhancements to InnoDB including Full Text Indexing on InnoDB tables.
Thankfully they have decided to use the same Full Text syntax as MyISAM tables so you shouldn't have to change anything to take advantage of their implementation and first impressions look very promising!
http://blogs.innodb.com/wp/2011/07/overview-and-getting-started-with-innodb-fts/
http://blogs.innodb.com/wp/2011/07/innodb-full-text-search-tutorial/
http://blogs.innodb.com/wp/2011/07/innodb-fts-performance/
Hopefully this will allow even better search performance out of the box for XF when officially available as GA.