robert_gsfame Posted July 10, 2010 Share Posted July 10, 2010 Can anyone point me out how can i create the most efficient search engine for my website.. if i use SELECT * FROM table WHERE record REGEXP '[[:<:]]%s[[:>:]]'= 1 will this avoid me of getting the search result faster when there are million of records in my database?? i try to google n read some article about FULL TEXT but i always find error when using that..i m not really sure what cause this but i have INT, VARCHAR n TEXT type in one of my table thx Quote Link to comment https://forums.phpfreaks.com/topic/207329-faster-search-engine/ Share on other sites More sharing options...
jskywalker Posted July 10, 2010 Share Posted July 10, 2010 but i always find error when using that This will be hard to find out what happened... If you give the code that you tried + the error it gave..... Someone here could give a clue on what went wrong, or give tips on how to make it quicker.... Quote Link to comment https://forums.phpfreaks.com/topic/207329-faster-search-engine/#findComment-1083998 Share on other sites More sharing options...
fenway Posted July 10, 2010 Share Posted July 10, 2010 FULLTEXT is the best internal way to go... Quote Link to comment https://forums.phpfreaks.com/topic/207329-faster-search-engine/#findComment-1084219 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.