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" <[EMAIL PROTECTED]>
To: "NYPHP Talk" <[email protected]>
Sent: Thursday, October 18, 2007 3:15 PM
Subject: Re: [nyphp-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
_______________________________________________
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
