Thought I would start here for some direction with this problem. .. 20 + seconds to render a asp page with a sql query.
I am trying to bring my IIS 6 - sql 2000 - ASP site over to ..... 2008 R2 - IIS7 - sql 2008 express.
A problem is how long it takes to render a page with server code.
EX:
ASP page with just a simple select command bringing back one record...
results = up to 20 seconds
Pages without sql code normal response
in sql manager... execution of stored procedures work fine
Looking for things to check.. litte experience with newer software
thanks
mark
...
Go to the complete details ...