Re: Fastest way to get table records' number
| From: | Shelley | Date: | Thu, 20 Mar 2008 04:55:46 +0000 |
| Subject: | Re: Fastest way to get table records' number | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-271874@lists.php.net to get a copy of this message | ||
Nathan Nobbe wrote:
On Wed, Mar 19, 2008 at 9:42 AM, Andrew Ballard <aballard@gmail.com> wrote:http://phparch.cn/index.php/mysql/35-MySQL-programming/126-fastest-way-to-get-total-records-from-a-table -- Regards, Shelley ( PHP Architecture: http://phparch.cn )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 The archive of my results was saved here: