<?php $links = mysql_connect('localhost','root','root') or die ('mysql connect faild'); mysql_select_db('test'); mysql_query('set names utf8'); set_time_limit(0); $time = microtime(true); for ($i=0; $i < 100000; $i++) { $sql = "INSERT INTO test(a,b) values ('a','b')"; mysql_query($sql); } echo microtime(true) - $time;
<?php $links = mysql_connect('localhost','root','root') or die ('mysql connect faild'); mysql_select_db('test'); mysql_query('set names utf8'); set_time_limit(0); $time = microtime(true); mysql_query('BEGIN'); $sql = "INSERT INTO test(a,b) values "; for ($i=0; $i < 1000000; $i++) { $sql .= "('a','b'),"; } $sql = substr($sql, 0, -1); mysql_query($sql); mysql_query('COMMIT'); echo microtime(true) - $time;