slow ASP-SQL database connection

[John Davis]

My ASP pages have very slow connections with SQL Server database, although
eventually it will reach the page and get the results. The SQL Server
database and IIS are in the same machine, I have no idea why it will cause
the problem.

I just put this connection string as SSI:

strConnect="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MYDATABASE;Data Source=MYCOMPUTER"

Anyone has any ideas? Please advise. thanks!
John

 

[Bob Barrows]

How are you determining that it's the connection that is slow?

 

[John Davis]

I just migrated the database and web pages from one machine to another
machine. The speed of the original web pages are faster than the current
one.

I wonder if anything to do on IIS or SQL Server settings??

 

[John Davis]

I just migrated the database and web pages from one machine to another
machine. The speed of the original web pages are faster than the current
one.

I wonder if anything to do on IIS or SQL Server settings??

 

[Bob Barrows]

This question cannot be answered until you verify where the slowdown is
occurring. This will require some debugging to be done with your pages. Use
Response.write's to report on your code timing:

<%
dim t
t= now()
....
response.write datediff("s",t,now()) & "<BR>"
....
response.write datediff("s",t,now()) & "<BR>"
....

Bob Barrows