[nycphp-talk] Paging Strategies
Cliff Hirsch
cliff at pinestream.com
Thu Oct 18 15:15:09 EDT 2007
> 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
More information about the talk
mailing list