Fastest way to get the record count?

[Brian Dunning]

I've been doing the following to get the record count from a db. Is  
this the fastest?

select count(id) as `count` from tablename;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]