Re:See Twitter's SQL.
by fendale on Monday July 07, 2008 @07:20AM
(#238491)
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 ...
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 ...