#33248 [NEW]: mysql_select_db is so slow

From: homework at aofrozencity dot com Operating system: Windows 2003 Server PHP version: 4.3.11 PHP Bug Type: MySQL related Bug description: mysql_select_db is so slow Description: ------------ My webserver computer isn't in the same local with MySQL server computer. MySQL server computer is at the different building. I wrote the IP address of the MySQL server in web file on the webserver computer. I noticed that mysql_select_db downloaded a huge table file fully (over 10,000 rows) from the MySQL server computer to the webserver computer for about 20 seconds. After that, finally it started querying fast. When I refresh the page, mysql_select_db downloaded the file again for other 20 seconds. I already ping the webserver computer to the MySQL server computer. It was about 15ms. source here: $connect=mysql_pconnect(xxx.xxx.xxx.xxx(IP internet), ..., ...) or die(mysql_error()); mysql_select_db(..., ...) or die(mysql_error()); -- Edit bug report at http://bugs.php.net/?id=33248&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33248&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=33248&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=33248&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=33248&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=33248&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=33248&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=33248&r=needscript Try newer version: http://bugs.php.net/fix.php?id=33248&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=33248&r=support Expected behavior: http://bugs.php.net/fix.php?id=33248&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=33248&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=33248&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=33248&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33248&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=33248&r=dst IIS Stability: http://bugs.php.net/fix.php?id=33248&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=33248&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=33248&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=33248&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=33248&r=mysqlcfg