如何提高sql INSERT INTO的速度

Question

<?phph
$Q=mysql_query("SELECT case_number,boxes FROM master");
    while($arr=mysql_fetch_array($Q))

    {

             $s=trim($arr['case_number']);

             $noc=trim($arr['boxes']) ;

             $e=($s+$noc-1);


        for($x=$s;$s<=$e;$s++)
            {


                    mysql_query("INSERT INTO master_break (case_number) VALUES('$s')");

                    $x++;




        }

        }?>

Answer 1

make all your insert in one transaction speed up time significantly.

like

mysql_query('START TRANSACTION', $link); 
for ($i = 0; $i < 20; ++$i) 
{ 
   mysql_query("INSERT INTO master_break (case_number) VALUES('$s')", $link);
}
mysql_query('COMMIT', $link); 

see in http://www.slideshare.net/jwage/doctrine-2-not-the-same-old-php-orm slide 52