NYCPHP Meetup

NYPHP.org

[nycphp-talk] Paging Strategies

Ben Sgro (ProjectSkyLine) ben at projectskyline.com
Thu Oct 18 17:07:01 EDT 2007


Hello,

I've been struggling w/this issue lately. I looked into the PEAR library,
and started writing a wrapper for it.

Does anyone have some good open source code or know of  a 3rd party lib
that does pagination?

- Ben

----- Original Message ----- 
From: "Cliff Hirsch" <cliff at pinestream.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
Sent: Thursday, October 18, 2007 3:15 PM
Subject: Re: [nycphp-talk] Paging Strategies


>> 1) TWO-QUERY APPROACH
>> on every page view:
> FAILSAFE. An extra count query, but no worries.
>
>> 3) ONE QUERY, CACHE EVERYTHING
> What if the count changes between pages view? What if there are millions 
> of
> records -- awfully big fetch. What if you change the application down the
> road, which creates the potential for changes in row count between views?
> Lot's of state info to think about....
>
> My two cents...
> Cliff
>
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php 




More information about the talk mailing list