title: MySQL is faster than Redis. Am I missing something here?
body: <p>I've been considering using Redis in a project that uses a lot of writes. </p>
  
  <p>So, after setting it up on my server, I created a simple PHP script using Predis with a simple loop to add records. I also created a second script that does a similar thing, only on a MySQL table (InnoDB) using PHP's MySQLi.</p>
  
  <p>I ran a 10k loop, a 100k loop and a 500k loop and MySQL beat Redis every single time. In fact, the more records I added, the faster MySQL was compared to Redis.</p>
  
  <p>There's so much buzz (hype?) around Redis, that I want to believe I'm missing something here.</p>
  
  <p>Please educate me :)</p>
  
  <p>Thanks!</p>
  
  <p>Here's my Predis code:</p>
  
  <pre><code>for ($i=0; $i&lt;100000; $i++) {
      $predis-&gt;set('key'.$i, $i);
  }
  </code></pre>
  
  <p>Here's my MySQLi code:</p>
  
  <pre><code>for ($i=0; $i&lt;100000; $i++) {
      mysqli_query($db, "INSERT INTO test (`key`, `value`) VALUES ('key$i', $i)");
  }
  </code></pre>