Connection pooling is a place where a set of connections are kept and are used by the different programers with out creating conncections to the database(it means there is a ready made connection available for the programmers where he can use). After using the connection he can send back that connection to the connection pool. Number of connections in connection pool may vary.
Above answer was rated as good by the following members: pradeepkmr18
May 28, 2005 17:56:01
Chaitanya
RE: What is Connection Pooling
Connection pooling is the process of reusing the database connections created between the application and the database by then increasing the performance of the application.
Suppose that there is table in the database called 'employer' if a objects asks the application server to create a connection between the table and the object the appServer creates but it does not throw away the connection it keeps the connection information in a pool if again the object requires to connect to the table it doesn't require to create a new connection as the connection available in the connection pool can be reused.Hence increase in performance.
Connection Pooling is a technique used for sharing the server resources among requested clients. It was pioneered by database vendors to allow multiple clients to share a cached set of connection objects that provides access to a database.
Connection pooling is a place where a set of connections are kept and are used by the different programers with out creating conncections to the database(it means there is a ready made connection available for the programmers where he can use). After using the connection he can send back that connection to the connection pool. Number of connections in connection pool may vary.
Getting connection and disconnecting are tasks by itself which costs to the application perfomance so we should aovid it. To be more precise depending of the Max & Min connections parm set in the specific Appserver config it intially either gets the min set of ready to connections or would be request based till the max connections are used. Once DB operations are done the free DB connections are re-used.
Getting connection and disconnecting are tasks by itself which costs to the application perfomance so we should aovid it. To be more precise depending of the Max & Min connections parm set in the specific Appserver config it intially either gets the min set of ready to connections or would be request based till the max connections are used. Once DB operations are done the free DB connections are re-used.
Connection pooling means set of connections are available to connect after use this connection disconnect it then others can use it.It reduce the time and it can be reusable.Any number of connections can be used by user.
If u have used a sql or other datsbase and act on the data getting the connection and logging in is the part that takes the most time An application can easily spend several seconds every time it needs to establish a connection
The Connection Creation section described when connections are created. It described how several context instances can share the same connection. In this type of sharing operations from the different context instances are multiplexed onto the same connection.
1 
0