ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michał Małecki <misie...@poczta.onet.pl>
Subject Re: Best mechanism to read large datasets
Date Fri, 08 Jul 2005 21:02:21 GMT
I absolutly agree,queryWithRowhandler was my first shot, but if 
possible, stored procedure is the right solution; hopefully you can 
write it in Java ;)
Michal Malecki

>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