?
Solved

leaving ODBC connection open

Posted on 2007-03-27
1
Medium Priority
?
279 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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
Suggested Courses

621 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