title: Mysql query very slow within date range in timestamp
body: <p>There is one table in mysql table which has about 1.76 Million records and growing. Seems like the more records it has the slower it gets. It takes about 65 seconds to run a simple query below. Date_run is a timestamp field. I wonder if that makes it slower to run. Any suggestions that I can tweak in the Options File to make this babe faster?</p>
  
  <pre><code>select *
  from stocktrack
  where date(date_run) &gt;= '2014-5-22'
  and date(date_run) &lt;= '2014-5-29'
  </code></pre>
  
  <ol>
  <li>mysql version 5.6</li>
  <li>Windows 8.1 64 bit</li>
  <li>Intel Core i7-4770, 3.40Ghz 12gb RAM</li>
  </ol>