TED]>
Sent: Tuesday, September 18, 2001 12:19 PM
Subject: InnoDB vs MyISAM on COUNT(*) ... WHERE ...
> I'm thinking of switching to InnoDB, however - my application does a few
> COUNT(*) WHERE queries on large tables (somewhere between 50K
> and 2M rows)
>
> I'
I'm thinking of switching to InnoDB, however - my application does a few
COUNT(*) WHERE queries on large tables (somewhere between 50K
and 2M rows)
I've read up on InnoDB and its issues with COUNT(*) on entire tables,
but is there
a reason to assume that InnoDB is also slower when ther