php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
 [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-2022 The PHP Group
All rights reserved.
Last updated: Sat Jan 22 03:03:33 2022 UTC