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
50000 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 also did some other test:
I ceated two tables both only have two columns, and both load 50000 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 turns out that the query:
select count(*) from A; takes 0.19 sec
select count(*) from B; takes 32 sec
It looks like the query depend on the size of row.
If the query is using index, the query should not make difference. What can
I do to improve the query speed?
Thanks
Frank
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
