title: Slow MySQL UPDATE query
body: <p>I have a mysql table containing 400,000 rows</p>
  
  <p>whenever I run a PHP script to update one row, it takes about 3-4 seconds to do it.</p>
  
  <p>How can I optimize the update query?</p>
  
  <pre><code>UPDATE `weakvocab` SET `times` = times+1, `wrong` = wrong+1, `mtime` = 1284369979 WHERE `owner` = 'owner_name' AND `vocID` = 'ID_number' AND `type` = 'type_name';
  </code></pre>
  
  <p>This query is about updating user data after answering a question, so I need a fast query to give user a better experience in loading the next question.</p>
  
  <p>Thank you,</p>