Re: Fastest way to get table records' number

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Shelley <myphplist@xxxxxxxxx>
Subject: Re: Fastest way to get table records' number
From: "Nathan Nobbe" <quickshiftin@xxxxxxxxx>
Date: Tue, 18 Mar 2008 23:47:59 -0400
Cc: php-general@xxxxxxxxxxxxx
In-reply-to: <47E08BD4.70102@xxxxxxxxx>

On Tue, Mar 18, 2008 at 11:43 PM, Shelley <myphplist@xxxxxxxxx> 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

Follow-Ups:
- Re: Fastest way to get table records' number
  - From: Mikey
- Re: Fastest way to get table records' number
  - From: Andrew Ballard

References:
- Fastest way to get table records' number
  - From: Shelley

Prev by Date: Fastest way to get table records' number
Next by Date: Re: Closures
Previous by thread: Fastest way to get table records' number
Next by thread: Re: Fastest way to get table records' number
Index(es):
- Date
- Thread

[Index of Archives] [PHP Home] [Apache Users] [PHP on Windows] [Kernel Newbies] [PHP Install] [PHP Classes] [Pear] [Postgresql] [Postgresql PHP] [PHP on Windows] [PHP Database Programming] [PHP SOAP]

Powered by Linux