ID: 22558
Comment by: port at iname dot com
Reported By: danl at icarz dot com
Status: Bogus
Bug Type: Performance problem
Operating System: AIX
PHP Version: 4.2.3
New Comment:

This may be useful - From UnixODBC 2.2.0 Doco

Another useful hint. Somewho has been using PHP+DB2 on AIX via unixODBC
to a BIG IBM server (4 processors, bags of core etc), and finding it
was slow. It turns out there is a bug
in IBM's TCP/IP stack. after looking at this and setting this

$ su - db2inst1
$ db2set DB2TCPCONNMGRS=1

To quote "... the difference was UNBELIEVABLE !!!". Thanks Eric.


"This" is the following link
[url]http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/doent.d2w/report?last_page=list.d2w&fn=1006553[/url]

Remember - DB2 is a lot more complex than MySQL, and diagnosing issues
is not as simple as saying "it's slow". That's why there are highly
paid DBA's!

Additionally there's no information in this bug report about whether
the DB2 DB is on the same box, load, versions, what's been attepmpted
or any other information that could be remotely useful.


Previous Comments:
------------------------------------------------------------------------

[2003-03-05 16:42:04] [email]kalowskyphp.net[/email]

Just to answer this a bit further. DB2 uses ODBC as it's native
system, MySQL uses a private/custom interface. When one can optimize
for speed to a single protocol, DB2 worries about all protocols. It's
going to be slower no matter what you do.

------------------------------------------------------------------------

[2003-03-05 14:42:48] [email]iliaaphp.net[/email]

Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit [url]http://www.php.net/support.php[/url] as this bug system is not the
appropriate forum for asking support questions.

Thank you for your interest in PHP.

MySQL is designed for speed DB2 is designed for scalability & large
applications where stability & data integerity is more important then
speed. Hence the difference you are seeing, as is this is NOT a php bug
or even a PHP related issue.

------------------------------------------------------------------------

[2003-03-05 14:13:53] danl at icarz dot com

Table structures on DB2 and MYSQL are the same, yet DB2 always seems to
take about 200ms as compared to 20ms on MYSQL. Any information would be
greatly appreciated.

------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=22558&edit=1[/url]