[development] MySQL SELECT COUNT(*) vs. COUNT(col1)

[Khalid Baheyeldin]

This is a good article explaining the difference between
COUNT(*) vs. COUNT(column) depending on the column
you use.

http://www.mysqlperformanceblog.com/2007/04/10/count-vs-countcol/

Also, note that InnoDB COUNT is generally slower than MyISAM's
always up to date COUNT.
-- 
2bits.com
http://2bits.com
Drupal development, customization and consulting.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20070502/031e82bb/attachment-0001.htm