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 Link to comment https://forums.phpfreaks.com/topic/109316-solved-varchar64000-search/ Share on other sites More sharing options...
jaymc Posted June 10, 2008 Author Share Posted June 10, 2008 Any ideas? Link to comment https://forums.phpfreaks.com/topic/109316-solved-varchar64000-search/#findComment-562250 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. =( Link to comment https://forums.phpfreaks.com/topic/109316-solved-varchar64000-search/#findComment-562622 Share on other sites More sharing options...
jaymc Posted June 10, 2008 Author Share Posted June 10, 2008 Dam Ok Link to comment https://forums.phpfreaks.com/topic/109316-solved-varchar64000-search/#findComment-562625 Share on other sites More sharing options...
fenway Posted June 11, 2008 Share Posted June 11, 2008 Lucene/Sphinx? Link to comment https://forums.phpfreaks.com/topic/109316-solved-varchar64000-search/#findComment-563049 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.