A RowHandler is the best way to process a large data set one record at a time. But if you actually want to limit the number of rows, you can use a paginated list, or queryForList with an offset and max rows.
Also consider the following attributes for optimization, althought their depdendent on your driver: Depends on your database, your driver, your configuration and attributes such as <select ... fetchSize="..." resultSetType="..."/> Cheers, Clinton On Thu, 17 Feb 2005 20:46:24 -0700, Brandon Goodin <[EMAIL PROTECTED]> wrote: > Using a RowHandler would work best. You would have to implement the > resulset size. But, it will give you the control you want regarding > row by row processing. > > Brandon > > On Wed, 16 Feb 2005 11:56:06 -0500, Carl Brodeur > <[EMAIL PROTECTED]> wrote: > > > > Hi: > > > > Is there a way to limit the size of the List returned by a find query > > in IBatis ? > > > > We have a query returning 3000 rows. iBatis creates an instance of the > > object corresponding object for each row returned. Caching is not > > possible in that particular case. > > > > >
