Re: Saving loading time at counting rows
| From: | Per Jessen | Date: | Sun, 13 Jul 2008 08:36:01 +0000 |
| Subject: | Re: Saving loading time at counting rows | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-276720@lists.php.net to get a copy of this message | ||
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.
>
> The problem is, there is a notable difference in loading time with
> other pages. Is there a technique to estimate the number of rows
> instead of exactly couting them? So that it saves loading time.
How about:
SELECT COUNT(*) FROM table WHERE <criteria> ?
/Per Jessen, Zürich