Forum Moderators: open

Message Too Old, No Replies

Alternative to Full Text search on InnoDB engine

         

viktor

3:24 pm on Nov 9, 2009 (gmt 0)

10+ Year Member



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)

10+ Year Member



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)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



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.