diablo_hacker
New Member
I have a classic ASP (vbscript) web app that connect to an SQL server. On certain pages, I open multiple DB connections to pull data. My question is:Is it better to add a close connection function at the bottom of each page or to explicitly close the connection right after using it? Keep in mind, on these certain pages, I reopen a DB connection everytime I get data; I do not reuse the connection. IE:\[code\]Set DBread = Server.CreateObject("ADODB.Connection")DBread.Mode = adModeReadDBread.Open (SQL_DB_CONN)\[/code\]When I close the connection, I use:\[code\]DBread.CloseSet DBread = Nothing\[/code\]So, should I constantly open then close the connection OR constantly open connections, then close them once at the end of a page?