Solved

leaving ODBC connection open

Posted on 2007-03-27
1
271 Views
Last Modified: 2008-02-01
Hello experts,

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.

Thanks!
0
Comment
Question by:js_vaughan
1 Comment
 
LVL 8

Accepted Solution

by:
jawahar_prasad earned 500 total points
ID: 18806030
Hi..
If you leave it open.. any other requests to the database will be blocked, and the requests have to wait until the process is killed by the server...

It will definitely cause a huge delay in processing...

Just close the connection.. and you will experience rocket speed.....
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It's sometimes a bit tricky to use date functions in Oracle BPEL. I'll explain quickly how you can add N days to the current date. In a BPEL process this can be useful, and you can adapt it to fit your needs. First of all, let's see how to add 1 …
Styling your websites can become very complex. Here I'll show how SASS can help you better organize, maintain and reuse your CSS code.
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question