php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #58433 packet size
Submitted: 2008-11-26 09:45 UTC Modified: 2008-12-19 14:30 UTC
From: vdohnal at uniscomp dot cz Assigned: grant (profile)
Status: Closed Package: ingres (PECL)
PHP Version: 5.1.2 OS: SUSE Linux Enterprise server 10
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: vdohnal at uniscomp dot cz
New email:
PHP Version: OS:

 

 [2008-11-26 09:45 UTC] vdohnal at uniscomp dot cz
Description:
------------
Our php application connects through ingres driver and IngresNet to another linux server with data. Very simple select (one column from one table, 2000 rows) generates 1500 very small tcp packets and takes about 15 seconds. If I run the same select on same servers only through IngresNet, ingres needs only 45 packets and data are back during 1 second. The size of packets from PHP driver is 12-15 Bytes. Size of packets from IngresNet is 1400 Bytes, all data are transfered very quickly by 1 or 2 packets.

Reproduce code:
---------------
<?php
error_reporting(2047);

print "Ingres Test\n";

//connect - db, user, password
$c = ingres_connect('iidbdb', 'ingres') or die ("connect failed");

if (is_resource($c))
{
        print "connect OK\n";
}

//query
$rs = ingres_query($c, 'SELECT table_name FROM iitables') or die('query failed');

if (is_resource($rs))
{
        print "query OK\n";
}

//rows
while($row = ingres_fetch_array($rs))
{
        print $row['table_name']."\n";
}

//commit
ingres_commit($c);
?>


Expected result:
----------------
ingres driver will use few tcp packets to transfer data

Actual result:
--------------
Ingres driver is using hundreds (thousands) of tcp packets

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2008-12-19 14:30 UTC] grant dot croker at ingres dot com
This bug has been fixed in CVS.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pecl.php.net.

In case this was a pecl.php.net website problem, the change will show
up on the website in short time.
 
Thank you for the report, and for helping us make PECL better.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 10:01:26 2024 UTC