Re: Re: google style paginating

IMHO a PEAR pager package sounds like a sledgehammer when all that's needed is a hammer. Cheers, Rob. On Fri, 2003-08-22 at 17:59, Rob Yelvington wrote: > 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. -- .---------------------------------------------. | Worlds of Carnage - http://www.wocmud.org | :---------------------------------------------: | Come visit a world of myth and legend where | | fantastical creatures come to life and the | | stuff of nightmares grasp for your soul. | `---------------------------------------------'