Re: Best mechanism to read large datasets

Fri, 08 Jul 2005 07:16:21 -0700

Title: Best mechanism to read large datasets
Can't you divide your result into pages with smaller number of records ?
 
queryForList with proper parameters should do that.
 
Darek
----- Original Message -----
Sent: Friday, July 08, 2005 4:10 PM
Subject: Best mechanism to read large datasets

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?


Reply via email to