Bug #11911 Updated: Speed Problem
| From: | cardinal@php.net | Date: | Sun, 15 Jul 2001 00:04:29 +0000 |
| Subject: | Bug #11911 Updated: Speed Problem | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-60041@lists.php.net to get a copy of this message | ||
ID: 11911
Updated by: cardinal
Reported By: aubrey@isoft.co.za
Old Status:
Status: Feedback
Bug Type: ODBC related
Operating System: Linux RedHat 7.1
PHP Version: 4.0.6
New Comment:
Setting status to feedback, status was blank.
Previous Comments:
------------------------------------------------------------------------
[2001-07-12 15:00:45] aubrey@isoft.co.za
just verifying that the user password works for this bug.
------------------------------------------------------------------------
[2001-07-09 08:44:54] 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-05 11:57:21] aubrey@isoft.co.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>";
}
*/
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=11911&edit=1