top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is connection pooling and how do you make your application use it?

+3 votes
380 views
What is connection pooling and how do you make your application use it?
posted Sep 15, 2015 by Jayshree

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

Using connection pooling multiple processes will share the same connection. where every parameter is the same including the security settings. Connection pooling increases the performance of the applications by reusing database connections.

answer Dec 15, 2015 by Manikandan J
0 votes

Opening database connection is a time consuming operation.
Connection pooling increases the performance of the applications by reusing the active database connections instead of create new connection for every request.
Connection pooling Behaviour is controlled by the connection string parameters.
Follwing the the 4 parameters that control most of the connection pooling behaviour.
1. Connect Timeout
2. Max Pool Size
3. Min Pool Size
4. Pooling

answer Dec 15, 2015 by Shivaranjini
...