DB connection location.
-
I pretty sure that someone came across the same dilemma: Where should I maintain the database connection object, should I open it once when the web application is started and close id when it is terminated or should I open and close it with each session. Which strategy is the one that is usually used ?
-
I pretty sure that someone came across the same dilemma: Where should I maintain the database connection object, should I open it once when the web application is started and close id when it is terminated or should I open and close it with each session. Which strategy is the one that is usually used ?
A database connection should be opened as late as possible and closed as soon as possible. So you should only open it when needed in your application, like when retrieving data to bind to a datagrid for instance, not when the initial page that only has static content is displayed.
only two letters away from being an asset