Recently I met a challenge for my autocomplete search (http://stackoverflow.com/questions/14923342/search-wildcard-multiple-columns-in-rails-using-one-param). I am using
"SELECT ... WHERE MATCH(...) AGAINST(...)" query, and noticed that I need to alter my table to
MYISAM. All my tables are currently
This table that I use is heavily updated. And then I need search 2 columns (name and address) in the table for autocomplete. This autocomplete will also be used heavily.
Being a noob, is it ok to change the table to
MYISAM? I'm not sure if it's worth to note, but I am also using
Sphinx as my search engine.
If there is any other solutions, such as changing the query, or using a different engine specifically for autocomplete, please suggest.