Re: Why doesn't the InnoDB count() match table status?

[Jochem van Dieten]

On 3/27/07, Tim Lucia wrote:
> > -----Original Message-----
> > From: Maciej Dobrzanski
> > Sent: Tuesday, March 27, 2007 6:46 AM
> > To: mysql@stripped
> > Subject: Re: Why doesn't the InnoDB count() match table status?
> >
> > MyISAM and InnoDB (and there are plenty more). RDBMS is not an Office
> > spreadsheet, you cannot simply change software as from OpenOffice Calc to
> > MS
> > Excel and expect everything will work the same. The migration can be done
>
> You can and ought to be able to expect it.  After all, SQL is a standard.

But the problem is not with the result of the query, but with the
speed. And the speed of an implementation is not standardized by the
ISO/IEC.

Jochem