#22558 [Bgs]: DB2 seems to be 10x slower than MYSQL running a simple select statement

ID: 22558 Updated by: kalowsky@php.net Reported By: danl at icarz dot com Status: Bogus Bug Type: Performance problem Operating System: AIX PHP Version: 4.2.3 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [2003-03-05 14:42:48] iliaa@php.net 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 http://www.php.net/support.php 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 http://bugs.php.net/?id=22558&edit=1