maestro360 — 2012-01-16T13:45:24-05:00 — #1
I have database I'm trying to extract my contacts from, which contains somewhere between 33,000 to 39,000 contacts. The reason I don't know the exact number is because everytime I refresh the query MySQL keeps giving me a varying total count.
Are total results provided by MySQL only estimations that are prone to fluctuate?
spacephoenix — 2012-01-16T14:57:07-05:00 — #2
Are you using a count query to count them or just a normal select and using something like mysqli_num_rows() (which is a PHP function to get the number of rows in a result set - asp and .net probably have equivalent functions)?
maestro360 — 2012-01-16T15:56:06-05:00 — #3
I'm getting the results straight from PHPMyAdmin, using just a simple SELECT statement. I guess this is a PHPMyAdmin issue rather than a MySQL issue. I hadn't thought to run a COUNT() query until reading your reply. This does bring back consistent results.
I guess it is PHPMyAdmin that draws the wildly varying estimates.
spacephoenix — 2012-01-17T02:54:37-05:00 — #4
When you run the simple SELECT statment against the database direct through php and not via phpmyadmin, do you get consistant results?