At 21:50 -0300 7/2/02, Crercio O. Silva wrote:
>PS: SELECT COUNT(*) FROM table is working just fine, but on InnoDB tables
>with large number of rows (my tables have -+ 300000 records each) it take a
>few seconds to get the results.
>This is not a big issue for me, but I'd like to confirm that.
Yes, this will happen with both InnoDB and BDB tables, which requlre
a full table scan to evaluate COUNT(*), even with no WHERE clause.
MyISAM and ISAM optimize that special case and return almost instantaneously.
|• Re: Re: BUG: SHOW TABLE STATUS & InnoDB Tables||Paul DuBois||3 Jul|