Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

leaving ODBC connection open

Posted on 2007-03-27
1
Medium Priority
?
278 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

610 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