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

Answer:

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
• Pooling

Please refer following link for more
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q169470