Re: InnoDB vs MyISAM on COUNT(*) ... WHERE ...

2001-09-18 Thread Dana Powers
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'

InnoDB vs MyISAM on COUNT(*) ... WHERE ...

2001-09-18 Thread Sander Pilon
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