Re: Limiting session pool size
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Fri, 17 Feb 2006 14:49:45 -0000
"Ken" <Ken@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C6CB8FEE-4267-4278-8FCC-16D3A7ADA0CC@xxxxxxxxxxxxxxxx
Is there a way to limit the size of an ADO session pool?
Note that I am not referring to the ODBC connection pool and this is ADO,
not ADO.NET.
Yes, so you are talking the OLE DB session pooling, right?
I am using SQLOLEDB in this particular instance. I have a
simple, single threaded application that opens a connection when it needsto
do some work, and then closes it again. Although most times it takes fromthe
pool, it occasionally opens up new connections even though there are
perfectly good ones in the pool.
Yes but are you following the rules?
If not the "perfectly good ones" may be ignored.
See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/pooling2.asp
and cursor halfway down to where OLE DB session polling is talked about.
See paragraphs with heading "Tips for OLE DB Users"
Stephen Howe
.
- Prev by Date: DataSet, Stored Procedures and Return Values
- Next by Date: Re: DataSet, Stored Procedures and Return Values
- Previous by thread: DataSet, Stored Procedures and Return Values
- Next by thread: Re: Limiting session pool size
- Index(es):
Relevant Pages
|
