List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 3 2002 4:00am
Subject:Re: Re: BUG: SHOW TABLE STATUS & InnoDB Tables
View as plain text  
sql,query

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.
Thread
Re: Re: BUG: SHOW TABLE STATUS & InnoDB TablesPaul DuBois3 Jul