RE: [PHP] Re: google style paginating
| From: | Chris W. Parker | Date: | Thu, 21 Aug 2003 23:48:20 +0000 |
| Subject: | RE: [PHP] Re: google style paginating | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-160369@lists.php.net to get a copy of this message | ||
Robert Cummings <mailto:robert@wocmud.org>
on Thursday, August 21, 2003 4:46 PM said:
> Don't retrieve ALL the queries then
> only display a subset. Otherwise what's the point of using the LIMIT
> clause for conservation of resources? The "SELECT COUNT( * ) FROM
> foo" query is usually optimized to be extremely fast so the first
> query is almost negligible in contrast to the second.
Heh... I've never really used COUNT() so I'll have to see how much it
speeds up my searching. :)
Good idea!
Chris.