ivytony Posted September 1, 2008 Share Posted September 1, 2008 I'm trying to create an application using PHP + MySQL which allows people to find a url stored in the database. Suppose there are thousands of urls stored in the database (like http://www.phpfreaks.com/forums/index.php/board,62.0.html, http://www.phpfreaks.com/forums/index.php/board,7.0.html, http://www.phpfreaks.com/forums/index.php/board,1.0.html, etc), how can I make the search for a particular url more efficiently? Can I still use this: Select url from url_table where url='$search_url' ? Is this efficient when there are many many urls stored in database? Link to comment https://forums.phpfreaks.com/topic/122265-how-to-make-url-search-query-efficiently/ Share on other sites More sharing options...
cooldude832 Posted September 1, 2008 Share Posted September 1, 2008 make sure you have indexing on the url field to aid in this You can also use a LIKE query to find urls "like" the inputted values however those will be slower but yield more results Link to comment https://forums.phpfreaks.com/topic/122265-how-to-make-url-search-query-efficiently/#findComment-631381 Share on other sites More sharing options...
fenway Posted September 2, 2008 Share Posted September 2, 2008 Searching "URLs" doesn't sound particularly user friendly... Link to comment https://forums.phpfreaks.com/topic/122265-how-to-make-url-search-query-efficiently/#findComment-631565 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.