Edit report at https://bugs.php.net/bug.php?id=63525&edit=1
ID: 63525 User updated by: admin at wudimei dot com Reported by: admin at wudimei dot com Summary: php5.4.8 connecting to mysql is slower then php5.2.6 -Status: Feedback +Status: Open Type: Feature/Change Request Package: MySQL related Operating System: windows 7 PHP Version: 5.4.8 Block user comment: N Private report: N New Comment: i use ip,not localhost. http://127.0.0.18/wudimei_show/admin_S2D3L56N8K5L/component_types.php?act=index Previous Comments: ------------------------------------------------------------------------ [2012-11-15 09:37:35] and...@php.net Can you try 127.0.0.1 instead of localhost and report the connect time? ------------------------------------------------------------------------ [2012-11-15 09:09:19] admin at wudimei dot com Description: ------------ php5.4.8 connecting to mysql is slower then php5.2.8 i use php5.4.8 to connect the mysql,it's slow!it take about 1.0138568878174 seconds. then i switch to php5.2.6 ,it only take 0.00234985351562 seconds. please improve it thank you! yang qingrong Test script: --------------- <?php $a = microtime( true ); $conn = mysql_connect("localhost","root","123456"); mysql_select_db("yqr"); $q = mysql_query("show tables"); while( $r = mysql_fetch_assoc( $q )) { print_r( $r ); } echo microtime(true ) - $a; echo " seconds"; exit(); ?> php5.4.8 output: Array ( [Tables_in_yqr] => account_book ) Array ( [Tables_in_yqr] => customer ) Array ( [Tables_in_yqr] => domain ) Array ( [Tables_in_yqr] => friends ) Array ( [Tables_in_yqr] => hourly_work ) Array ( [Tables_in_yqr] => hourly_work_project ) Array ( [Tables_in_yqr] => notepad ) Array ( [Tables_in_yqr] => notepad_ctg ) Array ( [Tables_in_yqr] => schedule ) 1.0138568878174 seconds php 5.2.6 output Array ( [Tables_in_yqr] => account_book ) Array ( [Tables_in_yqr] => customer ) Array ( [Tables_in_yqr] => domain ) Array ( [Tables_in_yqr] => friends ) Array ( [Tables_in_yqr] => hourly_work ) Array ( [Tables_in_yqr] => hourly_work_project ) Array ( [Tables_in_yqr] => notepad ) Array ( [Tables_in_yqr] => notepad_ctg ) Array ( [Tables_in_yqr] => schedule ) 0.00234985351562 seconds ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=63525&edit=1
