Re: Re: google style paginating

From: Date: Fri, 22 Aug 2003 21:59:27 +0000
Subject: Re: Re: google style paginating
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-160455@lists.php.net to get a copy of this message
The Pear Pager class works like a champeen, too. It'll paginate results however you'd like it to. ~Rob Chris W. Parker wrote:
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.


« previous php.general (#160455) next »