Incredibly Slow DB Connection

[LacrosseB0ss]

Hello All;

I have the following code in php. It was working fine up until last week or a bit before then the speed came to a grinding halt. Now when the page tries to load it gets stuck in the loop below. There are ~2500 records in the table (SQL database, not access).

Weird thing is, we have asp applications that run off this database also and they are fine. I copied the query into Query Analyzer and it produced all results within 2 seconds. Anyone have any idea why it times out after a full minute with only ~70% of the results?

$dbuser="otsuser";
    $dbpass = $dbuser; 
    $dbdsn = "Qualification Data";
    $con = odbc_connect($dbdsn, $dbuser, $dbpass) or die("Unable to connect to $dbdsn Database");
    $query = "select Emp_Id, Fname, Lname from employee WHERE Fname NOT LIKE 'Department' order by Fname, Lname";
 
$result = odbc_exec($con, $query);
    if ($result){
        $count = 0;
        while ( odbc_fetch_row($result) ){
            $emp_id = odbc_result($result, "Emp_Id");
            $fname = odbc_result($result, "Fname");
            $lname = odbc_result($result, "Lname");
            $fullName = $fname." ".$lname;
            $emp_ID[] = $emp_id;
            $emp_NAME[] = $fullName;
            $count = $count +1;
            echo "<br />" . $fullName; //testing purposes
        }
    } 
 

We have tried resetting the server, but that did not help. Also we are pretty sure it is not DB related. Thanks in advance for replies providing any insight
- LB

[steven]

Are you closing the db connection when you're finished with it or does this code use persistant connections?

Nothing really stands out in your code, that I can see anyway.

[LacrosseB0ss]

At the time I posted this yesterday, the connection wasn't being closed. We've started investigating this issue. To answer your question, the code timed out before getting to a spot where the connection could be closed, but no it wasn't closed anyway.

A semi-related question(s) then: If the code dies or a connection is left open, how long will the database connection remain open for? And, if another application that uses the database opens a connection without closing it, will it slow this one down? Is there a way to check if it's open before opening it?

Ok, so there was 3 questions. We're just out of options here. Sorry folks. Thanks for the reply though.
- LB