leaving ODBC connection open
Posted on 2007-03-27
I am trying to use Coldfusion to connect to a remote database using an ADODB.Connection (ODBC) . I know it is good practice to close these connections as soon as you are done, but what if i left it open? What would be the negative effects? The reason I ask is because obviously I am getting a slow response time trying to connect to a remote database, and am looking for ways to speed it up.