Re: Fastest way to get table records' number
| From: | Nathan Nobbe | Date: | Wed, 19 Mar 2008 03:47:59 +0000 |
| Subject: | Re: Fastest way to get table records' number | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-271764@lists.php.net to get a copy of this message | ||
On Tue, Mar 18, 2008 at 11:43 PM, Shelley <myphplist@gmail.com> wrote:
> Hi all,
>
> What do you think is the FASTEST sql to get the total number of a table
> with millions of records?
when you say 'total number' do you mean the total number of records? in
that case assuming the table has a field 'id' then i think
select count(id) from some_table;
-nathan