RE: Best mechanism to read large datasets

Fri, 08 Jul 2005 07:18:12 -0700

Title: Message
I would definitely like that, but unfortunately, that is not an option.
-----Original Message-----
From: Darek Dober [mailto:[EMAIL PROTECTED]
Sent: Friday, July 08, 2005 10:16 AM
To: [email protected]
Subject: Re: 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