php mysql多线程处理数据_关于php：如何使用多线程在mysql数据库中上传csv文件？...

我有一个csv文件，包含数百万个电子邮件地址，我想用PHP快速上传到mysql数据库。

现在我正在使用单线程程序，上传时间太长。

//get the csv file

$file = $_FILES['csv']['tmp_name'];

$handle = fopen($file,"r");

//loop through the csv file and insert into database

do {

if ($data[0]) {

$expression ="/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/";

if (preg_match($expression, $data[0])) {

$query=mysql_query("SELECT * FROM `postfix`.`recipient_access` where recipient='".$data[0]."'");

mysql_query("SET NAMES utf8");

$fetch=mysql_fetch_array($query);

if($fetch['recipient']!=$data[0]){

$query=mysql_query("INSERT INTO `postfix`.`recipient_access`(`recipient