Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Da_Retina
Posting Yak Master
109 Posts |
 Posted - 2002-05-09 : 07:02:02
|
| Can anyone tell me what exactly is a connection pool?..and where it is IMPLEMENTED?..ADO.NET says it manages it automatically!..so is it like a pool on the client managed by the ADO classes?..or is it on the SQL server?..How can I optimize my pools?..is the connection pool per program?..per session?...any info would be appreciated!Thanks------------------If I am to do it,I will, and NOW .. |
|
|
mohamedyousuff@yahoo.com
Starting Member
24 Posts |
Posted - 2002-05-09 : 08:23:52
|
Connection Pool is a technique by which the connection to the database is kept open, even if it is closed by the application which has opened it. Opening a connection to database is a bit time consuming. Hence Connection Pooling improves performance of the application to a great extent.The link below may be useful for youhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconconnectionpoolingforsqlservernetdataprovider.aspS.Mohamed Yousuffquote:
Can anyone tell me what exactly is a connection pool?..and where it is IMPLEMENTED?..ADO.NET says it manages it automatically!..so is it like a pool on the client managed by the ADO classes?..or is it on the SQL server?..How can I optimize my pools?..is the connection pool per program?..per session?...any info would be appreciated!Thanks------------------If I am to do it,I will, and NOW ..
Edited by - mohamedyousuff@yahoo.com on 05/09/2002 08:24:49 |
 |
|
|
|
|
|
Connection Pooling