Link to home
Start Free TrialLog in
Avatar of PeterErhard
PeterErhard

asked on

Connection Pooling and Length of time Connection is kept open

I'm maintaining an application where each user has their own connection string and the connection to the database is opened when the application is loaded and the connection is closed when the user exits from the application.

I've done some reading into connection pooling and it looks like a way better option. Would this be right?

Also, should the connection be closed, re-opened and closed again between calls to the database?

If both of these were implemented would there be a noticeable performance increase?
Avatar of PeterErhard
PeterErhard

ASKER

Any chance of some comments?
ASKER CERTIFIED SOLUTION
Avatar of arif_eqbal
arif_eqbal

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for your thoughts. :)

Does anyone else have any thoughts?