Re: Why would a SELECT COUNT(*)... WHERE... take way way longer than SELECT COUNT(primary_key)... WHERE... ?

[cvizitiu]

Alex Arul wrote:
count(*) is slow in innodb due to Multi Versioning. Which table type 
are you using ?


Hi Alex,

Thanks for answering; All tables are MyISAMs. I'm beginning to wonder if 
I am not taxed heavily for using floats for the geographic coordinates.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]