[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