title: Updating large MySQL table
body: <p>I have a table of 10000 product in my MySQL database. I would like to update all the records in a fastest way. I am using Laravel with MySQL. </p>
  
  <p>For better solution I can change technologies also. Right now it takes almost half hour to update the whole table.</p>
  
  <p>I would like to update that table in a fastest way. What should I do?</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I am using Laravel model like below</p>
  
  <pre><code>DB::table('products')-&gt;where('product_id',$product_id)-&gt;limit(1)-&gt;update(array('prodcut_quantity' =&gt; $prodcut_quantity));
  </code></pre>