Re: Connection Pooling and low use web site
From: mikemad (maddoxm_at_comcast.net)
Date: 01/13/05
- Next message: Ilann: "Jet OLEDB:New Database Password"
- Previous message: Binary Poet: "Re: How to add a record to a table?"
- In reply to: Paul Hatcher: "Re: Connection Pooling and low use web site"
- Next in thread: Sahil Malik: "Re: Connection Pooling and low use web site"
- Reply: Sahil Malik: "Re: Connection Pooling and low use web site"
- Messages sorted by: [ date ] [ thread ]
Date: 13 Jan 2005 10:16:10 -0800
I apologize for not putting more information in here. True, I don't
know for sure that it is connection pooling. Yes, it is an ASP.NET
application with SQL server on the backend using ADO.NET. This is also
on Windows Server 2003. The DB is on the same machine as the Website.
The scenario is like this. I go to the web site the first time, it
takes several seconds for the first page to come up. The first page
does access the database. I close the browser, open a new browser, then
go to the site and it's lightning fast. Next, I wait about 5 minutes
(could be even less, like 1 minute), go to the site, and the first page
is slow again. This happens either at home or work so I don't think
it's a proxy server thing. If it was ASP.NET compiling then I'd only
have this problem once, correct?? I'll try your suggestions with
running sp_who as well as trying to change the minimum connection pool
size. Any more info would be appreciated.
Mike Maddox
- Next message: Ilann: "Jet OLEDB:New Database Password"
- Previous message: Binary Poet: "Re: How to add a record to a table?"
- In reply to: Paul Hatcher: "Re: Connection Pooling and low use web site"
- Next in thread: Sahil Malik: "Re: Connection Pooling and low use web site"
- Reply: Sahil Malik: "Re: Connection Pooling and low use web site"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
