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:
Hi All!
We use MySQL 3.23.54 on dual-processor DELL running ReadHat 8.0 .
Performance of operations with one of the tables is very low .
For example :
mysql> select count(*) from protocol;
+--+
| count(*) |
+--+
| 2266 |
+--+
1 row in set (28.93 sec)
The table is creat
