ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: Best mechanism to read large datasets
Date Fri, 08 Jul 2005 15:14:18 GMT
Using queryWithRowhandler() as Michal suggested is the iBATIS solution. 

That said, I would seriously consider doing the process with a stored
procedure if possible. You will get WAY better performance, and reduce
network traffic significantly.

Larry


On 7/8/05, Rao, Satish <satish.rao@fmr.com> wrote:
>  
> 
> I have a situation where I might be retrieving thousands of rows from
> Oracle. I am using a queryForList() and I am assuming it stores the rows in
> memory. As a result I am quickly running out of memory. 
> 
> Is there a way for ibatis to read each row from table and discard it as soon
> as it is processed, so I don't run into out of memory issues? 
>

Mime
View raw message