asked on How to speed up an ASP/MS SQL web application
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.
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
Last Comment
Aleks
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
It runs fine on some installations but for one or two it runs very slow, the settings are identical.Are those installations in the same network?
ASKER
Different networks. I will spread the points. My client's IT will run a trace and index the DB and see if that helps.
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.