Thanks to both Dans, that's it. This even discussed in the refman, at (
http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html).
In my case, COUNT(*) found 25,682,600 rows and it took about 7 minutes.
Thanks,
Mike
In the last episode (Feb 21), Mike Spreitzer said:
> I have a table with millions of rows. I am not sure exactly how many rows
> it has, I get a different answer every time I ask! What's going on here?
>
> This DB is used only by me, and only by explicit commands --- I have no
> background or
Hi,
On 2/21/08 11:41 AM, "Mike Spreitzer" <[EMAIL PROTECTED]> wrote:
> I have a table with millions of rows. I am not sure exactly how many rows
> it has, I get a different answer every time I ask! What's going on here?
>
> This DB is used only by me, and only by explicit commands --- I have n
I have a table with millions of rows. I am not sure exactly how many rows
it has, I get a different answer every time I ask! What's going on here?
This DB is used only by me, and only by explicit commands --- I have no
background or on-line tasks using the DB. This is the DB that took 2 days
