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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
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: Sat Apr 27 11:01:30 2024 UTC