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

Khalid Baheyeldin kb at 2bits.com
Wed May 2 04:16:18 UTC 2007

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


Also, note that InnoDB COUNT is generally slower than MyISAM's
always up to date COUNT.
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 

More information about the development mailing list