Re: Saving loading time at counting rows
| From: | Robert Cummings | Date: | Sun, 13 Jul 2008 03:44:34 +0000 |
| Subject: | Re: Saving loading time at counting rows | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-276715@lists.php.net to get a copy of this message | ||
On Sat, 2008-07-12 at 23:22 -0400, tedd wrote:
> At 2:26 AM +0200 7/13/08, Joep Roebroek wrote:
> >I had this question, which I didn't really know where to ask, so I
> >thought to begin at this mailing list.
> >
> >Very basicly said, I count the rows of a table which had approx 50000
> >or more rows.
You are counting all the rows, or only rows mathcing a specific set of
criteria? Have you checked that you are indexing appropriate columns?
Cheers,
Rob.
--
http://www.interjinn.com
Application and Templating Framework for PHP