.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Home >> Forum >> ASP.Net >> Post New QuestionBookmark and Share Subscribe to Forum

Connection Pool

Posted By: RAJ     Posted Date: July 12, 2011    Points:5   Category :ASP.Net
what is the use of the connection poll and how can we use connection pool in asp.net where do we configure it.
plz give the brief information about connection pool
i mean where we use connection pool in real time?
how the internal process happen when we create the connection pool?
plz explain brefily.

Author: Ravi Ranjan Kumar             
Posted Date: July 12, 2011     Points: 20   

creating and Opening a connection to a data source can be a time consuming process. The problem increases in a multiuser environment where every user has one or more open connection to a data source and he data source is consuming too many resources just to manage the connections. this is where connection pooling can help.
The .Net framework data provider for SQL server provides connection pooling automatically for the ADO.NET client applications.
Connection pooling enables a data source to reuse connection for a particular user. it also improve performance and enhances scalability.

when an application attempts to open a connection. the Pooler examines the security context and the Polling property of the connection strings, and takes one of the following actions:
if the pooling property is false, the pooler opens a new connection rather than attempting to acquire from a pool.
if the pooling property is true, which is the default setting, the pooler attempts to acquire a connection from a pool.

For more Details you should read an excellent article at given links

Thanks & Regards
Ravi Ranjan Kumar
Author: kamlesh             
Posted Date: July 12, 2011     Points: 20   

Check below Link:


Thanks And Regards.
Kamlesh Nikam

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend