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
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Hsiu-Hui Tseng [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, November 06, 2003 3:41 PM
-->To: [EMAIL PROTECTED]
-->Subject: select count(*
