On Fri, 04 Mar 2016 00:35:47 -0800 Darren Duncan <darren at darrenduncan.net> wrote:
> > How exactly is the first way "easiest"? > > If these are pages displayed to the user, they may want to scroll > backwards at some point; They might, and if you say it's easier to go back to the database than to keep track of previously fetched data for re-display then, thanks, at least I understand your point of view. For myself I can't imagine such a design. After I've gone to the work of preparing the query fetching the results, and placing them in whatever construct is needed for display to the user, I'd certainly hang onto my display structures until the user was done with the data. If the user wants to see it again, the last thing I'd want to do is repeat all that. Sometimes it's faster to recompute something than to cache it for later re-use. That's rare where I/O is involved, and vanishing rare where SQL is involved. --jkl
