|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2008-12-19 14:30 UTC] grant dot croker at ingres dot com
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Oct 26 15:00:01 2025 UTC |
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