At 15:41 -0800 11/6/03, Hsiu-Hui Tseng wrote:
Hi,
select count(*) is very slow in innodb (because it is a table scan). Is
there any difference if I change it to select count(column).
I did some test and some times select count(*) is really slow and some time
select count(column) is slow. Could any
t: select count(*) / select count(column) in innodb
-->
-->Hi,
-->
-->select count(*) is very slow in innodb (because it is a table scan).
Is
-->there any difference if I change it to select count(column).
-->
-->I did some test and some times select count(*) is really slow and
Hi,
select count(*) is very slow in innodb (because it is a table scan). Is
there any difference if I change it to select count(column).
I did some test and some times select count(*) is really slow and some time
select count(column) is slow. Could anyone help me?
If I need do a select(*) in inn