2levelsabove Posted November 1, 2008 Share Posted November 1, 2008 Hello, I am working on an automotive related site and am running into a wall. As the database is getting bigger, the searches seem to be getting slower and slower. You can see an example at http://alltherides.com/search.html Please give me some ideas and feedback as what I can do. I need the searches to be fast but am not that experienced in this domain. Any help will be greatly appreciated. Thanks Link to comment https://forums.phpfreaks.com/topic/130985-how-can-i-speed-up-my-searches/ Share on other sites More sharing options...
Mchl Posted November 1, 2008 Share Posted November 1, 2008 If you showed us how tables in your database are created and how you're performing searches, it would help. Link to comment https://forums.phpfreaks.com/topic/130985-how-can-i-speed-up-my-searches/#findComment-679978 Share on other sites More sharing options...
GingerRobot Posted November 1, 2008 Share Posted November 1, 2008 The first thing to check would be that you have indexes on the fields you are searching on. Link to comment https://forums.phpfreaks.com/topic/130985-how-can-i-speed-up-my-searches/#findComment-680071 Share on other sites More sharing options...
2levelsabove Posted November 1, 2008 Author Share Posted November 1, 2008 I know what indexes are. However slightly confused as to what fields I will be placing indexes on ? Users can search for cars using make and model Link to comment https://forums.phpfreaks.com/topic/130985-how-can-i-speed-up-my-searches/#findComment-680278 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.