一次性往mysql中插入10万条数据,只需7秒
$connect_mysql->autocommit(false);
mysqli_query($connect_mysql,'set names utf8');
$begin = time();
$sqls ='';
for($i=1;$i<=100000;$i++){
$sqls .= "('....','.....','.....'),";
if($i%10000=='0'){
$sql = 'INSERT INTO `table` (`field1`,`field2`,`field3`) value'.rtrim($sqls, ",");
mysqli_query($connect_mysql,$sql);
$sqls ='';
unset($sql);
}
}
$end = time();
echo "用时 ".($end-$begin)." 秒 <hr/>";