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
John Davis wrote:
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" <re*******@yahoo.com> wrote in message
news:OK**************@TK2MSFTNGP12.phx.gbl... How are you determining that it's the connection that is slow?
John Davis wrote: 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