chantown Posted December 11, 2007 Share Posted December 11, 2007 Hi, I just built a forum, and currently, I am indexing EVERY post as full-text. When users run a search, the SQL is like this: SELECT ... FROM ..WHERE MATCH AGAINST ... Wouldn't this take a long time if there are thousands of posts? Is there any way I can speed it up or cache it or something? Should I index every word ?? or filter it somehow to speed it up? Link to comment https://forums.phpfreaks.com/topic/81133-how-should-i-make-a-search-engine-for-my-forum/ Share on other sites More sharing options...
walter8111 Posted December 11, 2007 Share Posted December 11, 2007 when I was setting up my forum I took a close look at the PHPBB forum, I't's a great example and they do have a rather good search engine. 2nd possibility is to use Google Power (but you'll loose some options like search by author or search by date) Link to comment https://forums.phpfreaks.com/topic/81133-how-should-i-make-a-search-engine-for-my-forum/#findComment-411878 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.