Connection pooling Examples

[Tarik Ansari]

Hello,

Can somebody explain what does connection pooling mean by simple samples? i want to learn it in simpler terms, google search gives results which makes me more confused.

thanks in advance
tarik

[Devaka Cooray]

Pooling means using some cache entries for the purpose of reusing. In particular for the connection pooling, it stores the connection (eg: database connection) in a 'pool' which is cached. With that case, we can reuse the same connection later without reconnecting.

[bala nannaka]

Creating or opening the connection for each request is a costliest operation.Costliest in means of consuming the time for every request is a serious problem.to overcome this creating the set of connections(pool of connections) at server startup time and make them availble to the application is a good solution

[Tarik Ansari]

Thanks for your replies..

i need sample exercise of connection pooling from where i can learn and obviously make more confidence.

Thanks