From: [EMAIL PROTECTED] Operating system: Linux RedHat 7.1 PHP version: 4.0.6 PHP Bug Type: *General Issues Bug description: Speed Problem 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>"; } */ -- Edit Bug report at: http://bugs.php.net/?id=11911&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
