优化用于将27000 * 2密钥从纯文本文件插入到DB的代码

Question

I need to insert data from a plain text file, explode each line to 2 parts and then insert to the database. I'm doing in this way, But can this programme be optimized for speed ?

the file has around 27000 lines of entry
DB structure [unique key (ext,info)]

• ext [varchar]
• info [varchar]

code:

$string = file_get_contents('list.txt');  
$file_list=explode("
",$string);  
$entry=0;  

$db = new mysqli('localhost', 'root', '', 'file_type');  
$sql = $db->prepare('INSERT INTO info (ext,info) VALUES(?, ?)');  

$j=count($file_list);  
for($i=0;$i<$j;$i++)  
{  
 $data=explode(' ',$file_list[$i],2);   
 $sql->bind_param('ss', $data[0], $data[1]);  
 $sql->execute();  
 $entry++;  
}   
$sql->close();  
echo $entry.' entry inserted !<hr>';

Answer 1

Here is the magic solution [3 seconds vs 240 seconds]

ALTER TABLE info DISABLE KEYS;

$db->autocommit(FALSE);
//insert
$db->commit();

ALTER TABLE info ENABLE KEYS;