title: PHP Query taking a while to return results
body: <p>i am running the below MySQL Query in PHP on my web server, the database is located on a separate server:</p>
  
  <pre><code>$sql="select * from call_history where extension_number = '0536*500' and flow = 'in' and DATE(initiated) = '".date("Y-m-d")."' ";
  $rs=mysql_query($sql,$pbx01_conn);
  echo mysql_num_rows($rs).' Calls IN';
  </code></pre>
  
  <p>the <code>call_history</code> table has thousands of rows in, is there any way to speed up the query?</p>
  
  <p><em>Please note: I only have read only access to the database</em></p>