If you want to retrieve a huge volume of rows you will end up with an
OutOfMemoryException due to the jdbc driver. Setting batchSize to -1 in your
data-config.xml (that internally will set it to Integer.MIN_VALUE) will make
the query to be executed in streaming, avoiding the memory exception.
Joe
A bigger batchSize results in increased memory usage. I guess
performance should be slightly better with bigger values but not
verified.
On Wed, Dec 23, 2009 at 2:51 AM, Joel Nylund wrote:
> Hi,
>
> it looks like from looking at the code the default is 500, is the
> recommended setting for this?
