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? Quote 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) Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.