ID: 11911
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Feedback
Bug Type: ODBC related
Operating System: Linux RedHat 7.1
PHP Version: 4.0.6
New Comment:
OK - I have recompiled with --with-iodbc and it is the same i.e. Very slow under linux.
Previous Comments:
------------------------------------------------------------------------
[2001-07-14 20:04:29] [EMAIL PROTECTED]
Setting status to feedback, status was blank.
------------------------------------------------------------------------
[2001-07-12 15:00:45] [EMAIL PROTECTED]
just verifying that the user password works for this bug.
------------------------------------------------------------------------
[2001-07-09 08:44:54] [EMAIL PROTECTED]
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-05 11:57:21] [EMAIL PROTECTED]
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 this 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]
