Re: Slow first connection to SQL Server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tommy Martin (tmartin_at_DONTSPAMMEtlmartin.com)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 05:51:10 -0500

I thought about that. I created a windows forms app and used the same
technique to connect and it does not show that problem. The connection is
instantanious as it should be.

Only ASP.NET apps are having this problem.

Tommy

"Lucas Tam" <REMOVEnntp@rogers.com> wrote in message
news:Xns95797186CE41nntprogerscom@140.99.99.130...
> "Tommy" <tmartin@xspam-tlmartin.com> wrote in
> news:uTN$Z$oqEHA.1952@TK2MSFTNGP12.phx.gbl:
>
>> It is the connection itself that is the problem. The page loads very
>> fast. Its when i click my button and hit the db to get some data that
>> the problem arises.
>
> I'm having the same problem as well... I know .NET uses connection
> pooling,
> so maybe the connection pools need to be reinitialized if the connections
> have been idle too long?
>
> I haven't figured out why it takes so long relatively speaking to
> reconnect.
>
> --
> Lucas Tam (REMOVEnntp@rogers.com)
> Please delete "REMOVE" from the e-mail address when replying.
> http://members.ebay.com/aboutme/coolspot18/

Quantcast