When you want to connect to the database, you have to open database connection which decreases the performance and also it is a time consuming operation. So with the help of connection pooling, you can increase the performance of the applications that is you can reuse the active database connections instead of creating new connection for each and every request made to the database. Its behavior is controlled by the connection string parameters. Below are 4 parameters which help to control connection pooling behavior.
• Connect Timeout
• Max Pool Size
• Min Pool Size
Please refer following link for more
Asked In: Many Interviews |