如何快速处理当PHP+Mysql 同时插入1W条数据时？

开启事务,注意超时和内存限制,建议在cli下插入.比如Ubuntu(i5-3230M),开启事务时,PHP往SQLite插入100万条记录只用16秒,平均每秒插入62500条.
`<?php
$table = 'CREATE TABLE logs (

 id       INTEGER PRIMARY KEY,
 date     VARCHAR(19) NOT NULL,
 content  VARCHAR(200) NOT NULL

)';
if (!file_exists('data.db3')) {

 $dbh = new PDO('sqlite:data.db3');
 $dbh->query($table);

} else {

 $dbh = new PDO('sqlite:data.db3');

}
$date = date('Y-m-d H:i:s');
$content = time();
$dbh->beginTransaction();
for($i=0;$i<1000000;$i++) {

 $stmt = $dbh->prepare('INSERT INTO logs (date, content) VALUES (:date, :content)');
 $stmt->bindParam(':date', $date, PDO::PARAM_STR, 19);
 $stmt->bindParam(':content', $content,  PDO::PARAM_STR, 200);
 $stmt->execute();
 $stmt = null;

}
$dbh->commit();
$dbh = null;
`