> 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
