title: Slow updates/inserts on Wordpress site
body: <p>I've got a website that now got updates/inserts that shows up in the slow-log file.
  There are a few tables built in a similar way, such as:</p>
  <pre><code>    CREATE TABLE `custom_order` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `userid` int(11) DEFAULT NULL,
      `orderdate` datetime DEFAULT NULL,
      `updatedate` datetime DEFAULT NULL,
      `orderdata` text DEFAULT NULL,
      `hash` varchar(255) DEFAULT NULL,
      `status` tinyint(4) DEFAULT NULL,
      `ordertype` tinyint(4) DEFAULT NULL,
      PRIMARY KEY (`id`),
      KEY `userid` (`userid`),
      KEY `ordertype` (`ordertype`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  </code></pre>
  <p>When the user finishes a function on the website, it will result in updates like this, where only the id is used to perform the update.</p>
  <pre><code>    $wpdb-&gt;update(&quot;custom_order&quot;, 
          array('status' =&gt; $status,
                'updatedate' =&gt; current_time('mysql'),
                'orderdata' =&gt; $orderdata,
          ),array(&quot;id&quot; =&gt; $orderid));
  </code></pre>
  <p>The table got about 200.000 rows.</p>
  <p>Any ideas on what to change to speed things up with this kind of update?
  Thanks!</p>