title: Execution time of a mysql query, slow in php than phpmyadmin . How I can overcome this
body: <p>I was running a query in phpmyadmin, it takes around 0.0012 sec to execute.</p>
  
  <pre><code> Showing rows 0 - 29 ( 727,934 total, Query took 0.0012 sec)
  </code></pre>
  
  <p>may be because of by default limitation in phpmyadmin. But it count the total no of row.</p>
  
  <p>But in php, I need the total no of row .I was running the query without limitation that takes around 6-8 second of time to execute the query.</p>
  
  <p>is their any way to solve this issue.</p>