Hi!
On Dec 04, Gurupartap Davis wrote:
> I'm converting a table to innodb from myisam in mysql 4.0 and I was
> wondering why it takes sooo long to do a SELECT COUNT(*)
MyISAM stores total number of rows in MYI file header.
It's read into memory when table is opened.
So for SELECT COUNT(*) FROM
I'm converting a table to innodb from myisam in mysql 4.0 and I was
wondering why it takes sooo long to do a SELECT COUNT(*)
In the old MyISAM table, it's quick:
mysql> select count(*) from forecast;
+---+
| count(*) |
+---+
| 194698187 |
+---+
1 row in set (0.00 sec)
In
