Hi all, when retrieving data from a DB a sometimes don't want to fetch all data, e.g I want to fetch 100 rows at a time. E.g. when I allow a user to page through a ton of results I would like to only fetch the next page.
I would therefore need some Criteria to say fetch rows from n to m only. I know that some (most?) databases do not support that. But say I need objects #no 98200 to 98300 it would be a massive overhead to go an create 98000 objects of which 99% are then thrown away. Maybe some kind of lazy instantiation of an object could help. There is an Iterator interface associated with the PersistenceBroker, does this do lazy instantiation ? Thanks for any ideas, Stefan p.s resent since I did not receive the original back from the list --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
