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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your thoughts. :)
Does anyone else have any thoughts?
Does anyone else have any thoughts?
ASKER