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="Pro vider=SQLOLEDB. 1;Integrated Security=SSPI;P ersist Security
Info=False;Init ial Catalog=MYDATAB ASE;Data Source=MYCOMPUT ER"

Anyone has any ideas? Please advise. thanks!
John

[Bob Barrows]

Re: slow ASP-SQL database connection

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

John Davis wrote:[color=blue]
> 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="Pro vider=SQLOLEDB. 1;Integrated Security=SSPI;P ersist
> Security Info=False;Init ial Catalog=MYDATAB ASE;Data Source=MYCOMPUT ER"
>
> Anyone has any ideas? Please advise. thanks!
> John[/color]

[John Davis]

Re: slow ASP-SQL database connection

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" <reb_01501@yaho o.com> wrote in message
news:OKDKMOJfDH A.2332@TK2MSFTN GP12.phx.gbl...[color=blue]
> How are you determining that it's the connection that is slow?
>
> John Davis wrote:[color=green]
> > 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="Pro vider=SQLOLEDB. 1;Integrated Security=SSPI;P ersist
> > Security Info=False;Init ial Catalog=MYDATAB ASE;Data Source=MYCOMPUT ER"
> >
> > Anyone has any ideas? Please advise. thanks!
> > John[/color]
>
>[/color]

[John Davis]

Re: slow ASP-SQL database connection

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" <reb_01501@yaho o.com> wrote in message
news:OKDKMOJfDH A.2332@TK2MSFTN GP12.phx.gbl...[color=blue]
> How are you determining that it's the connection that is slow?
>
> John Davis wrote:[color=green]
> > 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="Pro vider=SQLOLEDB. 1;Integrated Security=SSPI;P ersist
> > Security Info=False;Init ial Catalog=MYDATAB ASE;Data Source=MYCOMPUT ER"
> >
> > Anyone has any ideas? Please advise. thanks!
> > John[/color]
>
>[/color]

[Bob Barrows]

Re: slow ASP-SQL database connection

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:[color=blue]
> 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" <reb_01501@yaho o.com> wrote in message
> news:OKDKMOJfDH A.2332@TK2MSFTN GP12.phx.gbl...[color=green]
>> How are you determining that it's the connection that is slow?
>>
>> John Davis wrote:[color=darkred]
>>> 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="Pro vider=SQLOLEDB. 1;Integrated Security=SSPI;P ersist
>>> Security Info=False;Init ial Catalog=MYDATAB ASE;Data
>>> Source=MYCOMPUT ER"
>>>
>>> Anyone has any ideas? Please advise. thanks!
>>> John[/color][/color][/color]