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?