I have an ASP with MS SQL 2008 web application.
It runs fine on some installations but for one or two it runs very slow, the settings are identical. This two have more data in the database but nothing that should slow it down.
What kind of things can I do to speed it up ?
Index the DB ? if so how ? How would I 'run a trace' and then index based on that ?
Anything else that I could do to make the system faster ? seems like only pages with connection to the database are slow.
Web DevelopmentASPMicrosoft SQL ServerMicrosoft SQL Server 2008Web Applications
Well indexed dB, good queries and throw your data to an array instead of a recordset are the biggest without seeing what you are doing.