jaymc Posted June 8, 2008 Share Posted June 8, 2008 I am building a forum, all the tables are InnoDB I want a search feature so people can search for words in all posts. I tested this on a table i have which has 300,000 posts, it took 20 seconds Now I know with MYISQM you can put a fulltext index on, but innodb does not allow this For this feature, do i have to create a MYISAM table dedicated to storing just post_id and post_content to get the performance advantages of using the FULLTEXT index Or, is there something I can do with innodb to that field to optimize it for searches Cheers Quote Link to comment Share on other sites More sharing options...
jaymc Posted June 10, 2008 Author Share Posted June 10, 2008 Any ideas? Quote Link to comment Share on other sites More sharing options...
DarkWater Posted June 10, 2008 Share Posted June 10, 2008 Nope, FULLTEXT is the optimal way to do a search like that, and sadly only MyISAM supports it. =( Quote Link to comment Share on other sites More sharing options...
jaymc Posted June 10, 2008 Author Share Posted June 10, 2008 Dam Ok Quote Link to comment Share on other sites More sharing options...
fenway Posted June 11, 2008 Share Posted June 11, 2008 Lucene/Sphinx? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.