"search" / multiple page database select methods

[Keith Seim]

I have a generic "DSSearch" class that will hold both the primary 
Criteria for an online search-result form (Criteria.add and 
Criteria.addJoin), as well as integers representing the limit and 
offset.  This search class will be kept in session in order to allow for 
multi-page searches (where the limit and offset can change at any time).

My question is:  if the number of results (torque data objects) from my 
doSelect can be anything from 0-n (where n is likely less than 50,000), 
should I:

a) keep only the Criteria object, limit, and offset in Context; then for 
each page execute new doSelect defined by limit and offset, OR:
b) doSelect on Criteria on DSSearch instantiation, then keep the full 
result List (of n results) in Session, providing methods for the 
template programmer to get a limited set of the pre-existing List.

I'm sure both options will work, but I'd like to do it the "right" way.

Thanks!
___________________________________
Keith Seim • http://kjsdesigns.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]