I have an InnoDB Database and I need to do a Search on Text fields, Is there a way to get the MyISAM approach of the full text search on InnoDB?
Much appreciated.
Thanks
viktor
2:04 pm on Nov 10, 2009 (gmt 0)
I know that there is an API like Sphinx (www.sphinxsearch.com), and that i could create a slave table that could be on ISAM, but i would like to know if there is another alternative?
Thanks
topr8
3:04 pm on Nov 10, 2009 (gmt 0)
one common approach is to split the table in 2 and have the fields you want to fulltext search in a myISAM table and the rest in the InnoDB table.