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