Re: Fastest way to get table records' number

Nathan Nobbe wrote:

On Wed, Mar 19, 2008 at 9:42 AM, Andrew Ballard <aballard@gmail.com> wrote:

That works; I'm just wondering why you went with a count on an 'ID' column rather than COUNT(*).

ouch, it looks like im horribly wrong :O mysql> select count(*) from table; +----------+ | count(*) | +----------+ | 361724 | +----------+ 1 row in set (0.90 sec) mysql> select count(id) from table; +------------+ | count(did) | +------------+

|     361724 |

+------------+ 1 row in set (4.56 sec) -nathan Here is a further test with more records:

mysql> select count(*) from table1; +----------+ | count(*) | +----------+ | 20795139 | +----------+ 1 row in set (1 min 8.22 sec) mysql> select count(id) from table1; +-----------+ | count(id) | +-----------+ | 20795139 | +-----------+ 1 row in set (1 min 1.45 sec) mysql> select count(1) from table1; +----------+ | count(1) | +----------+ | 20795139 | +----------+ 1 row in set (56.67 sec) count(1) wins. -- Regards, Shelley ( PHP Architecture: http://phparch.cn )