On Wed, May 05, 2004 at 01:06:45PM -0400, Brent Baisley wrote:
> Basically, you can't, it's a limitation of the InnoDB format. If you
> change the table type to MyISAM, that query would be almost
> instantaneous. But you are probably using InnoDB for a reason, so you
> may be stuck if you want a
Brent Baisley wrote:
Basically, you can't, it's a limitation of the InnoDB format. If you
change the table type to MyISAM, that query would be almost
instantaneous. But you are probably using InnoDB for a reason, so you
may be stuck if you want a record count.
As Brent said, there is no way to o
Basically, you can't, it's a limitation of the InnoDB format. If you
change the table type to MyISAM, that query would be almost
instantaneous. But you are probably using InnoDB for a reason, so you
may be stuck if you want a record count.
On May 5, 2004, at 10:01 AM, Vladimir Romanovski wrote: