Re: Fastest way to get table records' number
| From: | Mikey | Date: | Wed, 19 Mar 2008 14:44:52 +0000 |
| Subject: | Re: Fastest way to get table records' number | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-271788@lists.php.net to get a copy of this message | ||
Nathan Nobbe wrote:
On Tue, Mar 18, 2008 at 11:43 PM, Shelley <myphplist@gmail.com> wrote:If you are talking about millions of rows then the fastest way is to put a trigger on create and delete on the table in question that updates a single column in another table that is a counter. HTH, MikeyHi 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