Mentioned elsewhere in this thread, but count() and count(1) mean basically the same thing and are equivalent. There is a nice optimisation in MYISAM table tha

Mentioned elsewhere in this thread, but count() and count(1) mean basically the same thing and are equivalent. There is a nice optimisation in MYISAM table that makes count() from table <with no where clause> almost instant as its stored as meta-data on the table - in InnoDB, Oracle or Postgres this optimisation doesn't exist ...