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 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.... 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... Link to comment https://forums.phpfreaks.com/topic/207329-faster-search-engine/#findComment-1084219 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.