This is a good article explaining the difference between <br>COUNT(*) vs. COUNT(column) depending on the column<br>you use.<br><br><a href="http://www.mysqlperformanceblog.com/2007/04/10/count-vs-countcol/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.mysqlperformanceblog.com/2007/04/10/count-vs-countcol/</a><br clear="all"><br>Also, note that InnoDB COUNT is generally slower than MyISAM's<br>always up to date COUNT.<br>-- <br><a href="http://2bits.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
2bits.com</a><br><a href="http://2bits.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://2bits.com</a><br>Drupal development, customization and consulting.