Our application which is in classic ASP needs some housekeeping. Either to rewrite the whole thing again in some other language preferably PHP or making the existing one faster. In short term the later is preferred. Hence I was looking for suggestions.
1. Our database is growing at a large pace, when we designed the site there were just 100 users and now it has grown to more than 3000.
2. Although The SQL queries do not take time to execute in actual MySQL interface, there is some delay when the application runs.
I want your expertise on this to suggest ways to make the existing ASP application faster.
Does changing the host will help? We are on shared hosting with godaddy.