vicodin Posted February 22, 2008 Share Posted February 22, 2008 Iv been building a search engine for my site... I am wondering what is the faster way to do it. Should i get every result in the db and have php check if it matches the query or should i have mysql do the work and just enter the query into my Mysql statement??? Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted February 22, 2008 Share Posted February 22, 2008 Let the database server check it. There'll be a too large overhead on the database if you retrieve all the rows always. Imagine you have a million entries and a lot of page hits. You'd kill the server. You can use MySQL's fulltext searching capabilities. Quote Link to comment Share on other sites More sharing options...
vicodin Posted February 22, 2008 Author Share Posted February 22, 2008 Thanks for the reply... I am going to have keys words seperated by a | in one cell... is it possible to get myql to pull it into an array and tell it the keywords are seperated by a | and to check all the key words? Quote Link to comment 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.