一个mysql查询的执行时间，在php中比phpmyadmin慢。 我怎么能克服这一点

Question

I was running a query in phpmyadmin, it takes around 0.0012 sec to execute.

 Showing rows 0 - 29 ( 727,934 total, Query took 0.0012 sec)

may be because of by default limitation in phpmyadmin. But it count the total no of row.

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.

is their any way to solve this issue.

Answer 1

I have had a similar problem and in my case it was due to the fact that I was not using the correct data types. So while I wanted to query my VarChar Type Index Field with a VarChar I mistakenly formulated the query in such a way that I queried it with and Int Paramter. This resulted in the index not being utilized but rather a full table scan being performed. By example I did:

SELECT * FROM table WHERE Indexfield = 015523;

when I should have done the following:

SELECT * FROM table WHERE Indexfield = '015523';

There is some more insight into the issue here: https://www.percona.com/blog/2006/09/08/why-index-could-refuse-to-work/