php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #11911 Speed Problem
Submitted: 2001-07-05 11:57 UTC Modified: 2002-02-04 15:37 UTC
From: aubrey at isoft dot co dot za Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.6 OS: Linux RedHat 7.1
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2001-07-05 11:57 UTC] aubrey at isoft dot co dot za 
We have 2 machines, one NT and the other LInux. Both run PHP. The Linux machine runs Apache and the NT machine runs IIS 4.

The Linux machine is a database server. If we run the PHP script on the NT machine against the database on the Linux machine, the result is instantaneous, however if we run the script from the Linux machine against it's local database, it takes 20 seconds to respond.

The database method of access is via Openlink ODBC.

<html>
<head>
<meta http-equiv="refresh" content="10;url=http://ifusion.isoft.co.za/test.php">
</head>
<head>
<meta http-equiv="refresh" content="10;url=http://ifusion.isoft.co.za/test.php">
<H1> Omnix Interface into HEAT </H1>
<H2> Waiting for Transactions .............. </H2>
</head>

<?
//function dq($str) {
 //   $str = trim("\"".$str."\",");
//    return ($str);
//}
print "Running Test.php<BR>";

//$Err = "";
if (!($db = odbc_connect("Omnix000","","",1))) {
                print "****** There is no Omnix Server for Database sqlHEAT******";
                exit();
        }

$Sql = "select name from drsmas";
//$Sql .="WHERE jobcard <> ''";

$callLog = odbc_prepare($db,$Sql);
$x = odbc_execute($callLog);
//if ($x) PRINT "Good = $x" ;

//$callLog = odbc_exec($db,$Sql);
//print "No of rows= ".odbc_num_rows($callLog);
//while(odbc_fetch_row($callLog)){
/*for ($i = 1; $i < 10; $i++){
        //odbc_fetch_row($callLog);

        $name = odbc_result($callLog,1);
        print "data= $name <BR>";

}
*/

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-07-09 08:44 UTC] kalowsky@php.net 
on your linux build did you use --with-openlink or --with-iodbc?

if it was --with-openlink, try to rebuild using the --with-iodbc instead, as one is maintained, the other isn't ;)
 [2001-07-12 15:00 UTC] aubrey at isoft dot co dot za 
just verifying that the user password works for this bug.
 [2001-07-14 20:04 UTC] cardinal@php.net 
Setting status to feedback, status was blank.
 [2001-07-16 05:15 UTC] aubrey at isoft dot co dot za 
OK - I have recompiled with --with-iodbc and it is the same i.e. Very slow under linux.
 [2001-07-16 10:07 UTC] kalowsky@php.net 
marking as open, since the user last replied
 [2001-08-01 12:04 UTC] aubrey at isoft dot co dot za 
OK - I have recompiled with --with-iodbc and it is the same i.e. Very slow under linux.
 [2002-02-04 15:37 UTC] kalowsky@php.net 
This bug has been fixed in CVS.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Tue Apr 23 11:01:33 2024 UTC