On Thursday, August 2, 2001, at 04:07 AM, Joachim Zobel wrote:
> One of the really nice features of MySQL (OK, its not a "real" RDBMS,
> but who cares:) is LIMIT.
>
> Using Oracle I have found it a real pain to display search results in
> pages (of eg 20) while using connection pooling. The problem is that
> you can not be shure to repeat the same resultset on every page. This
> gets a real problem if the queries get expensive and I can't afford
> sorting because it destroys first row performance.
>
> Is there a generic soloution to this? Has anybody found this worth
> writing a pattern?
Sure! Just store the results in your session, and display from there...
--
-- Tom Mornini
-- ICQ 113526784