title: How to improve mysql INSERT query efficiency where there are large no of rows
body: <p>I have googled but didn't found any effective solution. I am having one small php file where only two <code>INSERT</code> queries are there (different tables). One table having around <code>3358500</code> rows and other table having around <code>679570</code> rows. I think because of large number of rows it's getting very slow for insertion. </p>
  
  <p>I though of using these:<br/>
  i) stored procedure (may not be effective in this case)<br/>
  ii) Using Transaction</p>
  
  <p>**Note: Using InnoDB engine</p>
  
  <p>Please provide me some other solutions apart from above two. Thanks!</p>