Solved

leaving ODBC connection open

Posted on 2007-03-27
1
268 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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
How to translate path in URL with PHP? 11 32
Format results with PHP 3 62
Microsoft Edge 9 83
React or Angular? 6 8
Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
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 …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now