Connection Pooling with application using single database

Question

Connection pooling is a new concept for me. I am working with a desktop application and using single database for this application.

Then i want to know that can i use connection pooling in my application to increase speed constraint.

Thanks in advance....

Eran Zimmerman Gonen · Accepted Answer · 2011-09-20 08:11:40Z

1

Initializing and destroying connections repeatedly is costly. Instead, what you may do is use a pool of connections. You initialize a collection of connections at the initialization phase of your application, and destroy it at the end. This way, each connection is only initialized and destroyed once.

Later on you can play around with other attributes of the pool, like whether its size stays fixed, or changes to meed demand, whether or not it is thread-safe, its size, etc. These should all be tuned for your specific application and specific needs.

answered Sep 20, 2011 at 8:11

Eran Zimmerman Gonen

4,5171 gold badge22 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connection Pooling with application using single database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related