Connection pooling, DOT NET Programming

Explain the fundamental of connection pooling.

Whenever a connection is opened first time a connection pool is created and is based on the exact match of the connection string given to create the connection object. This Connection pooling works only if the connection string is the same. If the connection string is different, then the new connection will be opened, and connection pooling won't be used.

Now try to describe the same pictorially. In the  figure above you can see that there are three requests viz. "Request1", "Request2" &  "Request3". "Request1" and "Request3" have same the connection string so no new connection object is created for the "Request3" as the connection string is same. They share the similar object "ConObject1". But the new object "ConObject2" is created for "Request2" as the connection string is different.

1222_connection pooling.png

Figure : -Connection Pooling action.

Posted Date: 9/24/2012 5:06:37 AM | Location : United States







Related Discussions:- Connection pooling, Assignment Help, Ask Question on Connection pooling, Get Answer, Expert's Help, Connection pooling Discussions

Write discussion on Connection pooling
Your posts are moderated
Related Questions
Describe all elements in Static Chart diagrams. Package: - The Package logically groups element of a UML model. Class: - The Class describes all set of objects with

What is the significance of Finalize method in .NET? The .NET Garbage collector does atmost all clean up activity for your objects. But unmanaged resources (like - Windows API

What are the naming conventions required for XML elements tags? The following are the naming conventions that need to be followed for XML elements tags: Element names should

What are benefits and limitations of using Cookies? The benefits of using cookies for state management are as follows:- 1)    There is no server resources required as they a

What is the relationship between a class and an object? A class acts as a blue-print that explains the properties, states, and behaviors that are common to a number of objects.

ASP.net developer for a mobile project I am looking for an Icenium developer using the Visual Studio extension and jquery. The application will incorporate with an already wr

Program for Solution of Linear Equations - C# Program Hello, I've been trying so many codes for this but those codes didn't work well. Please write a Program for solving Linea

How will you do code reviews? The way in which the code reviews are done change from person to person and also from company to company. But generally when a project is started

Explain Forms authentication in detail. In the old ASP if you were said to create a login page and do authentication you have to do lot of custom coding. But now in ASP.NET tha

Project Description: I require a custom texture painting plug-in for the latest version of Unity 3D. The project can have features that are common in Photoshop and Mari for pain