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

From: danl at icarz dot com Operating system: AIX PHP version: 4.2.3 PHP Bug Type: Performance problem Bug description: DB2 seems to be 10x slower than MYSQL running a simple select statement 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 bug report at http://bugs.php.net/?id=22558&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=22558&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=22558&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=22558&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=22558&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=22558&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=22558&r=support Expected behavior: http://bugs.php.net/fix.php?id=22558&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=22558&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=22558&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=22558&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=22558&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=22558&r=dst IIS Stability: http://bugs.php.net/fix.php?id=22558&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=22558&r=gnused