Dear sir,
I'm using mysql Ver 12.16 Distrib 4.0.5-beta, for Win95/Win98 (i32).
I have an innodb table which contains more than 40 columns, after it load
5 rows, the query:
select count(*) from t;
takes 11 seconds. while the same table with ISAM type, the query only takes
0.02 second.
I
From: Frank LIU [EMAIL PROTECTED]
I also did some other test:
I ceated two tables both only have two columns, and both load 5 rows.
Talbe A has two int type columns,
Table B has an int type as primary key, and a mediumblob column. I insert
a
4k data into blob column of each row.
It