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 Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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 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.