That's still a lot of records to return from a query, but sometimes you need that, too. Increasing the memory is probably appropriate, then.
/dev/mrg On 2/15/07, Frank <[EMAIL PROTECTED]> wrote:
My query returned less than 2700 records. My schema was large, about 190 fields. I trimmed this down to about 5 and increased the JVM. Regards, Frank ----- Original Message ----- From: "Michael Gentry" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, February 15, 2007 9:27 AM Subject: Re: OutOfMemoryErrors (solved) > Bumping the heap size up is probably fine, but I also suspect Frank > might be trying to read in too much data given his previous postings > using LIKE expressions. He may be getting back tens of thousands of > rows, if not more. Perhaps his application requires that, though. > > /dev/mrg > > > On 2/15/07, Andrus Adamchik <[EMAIL PROTECTED]> wrote: >> You are being too picky. Why is this not a solution? Default 64m heap >> size for the JVM is not enough for most applications nowadays ;-) >> >> Andrus >> >> >> On Feb 15, 2007, at 2:47 AM, Juergen Saar wrote: >> >> > This is a workaround, but not a solution ... >> > >> > -sorry- >> > --- Juregen --- >> > >> > 2007/2/14, Frank <[EMAIL PROTECTED]>: >> >> >> >> Hi Andrus, >> >> >> >> I bumped the JVM up to 512m >> >> This resolved my issue. >> >> I also removed AS400 fields not needed in my query to help reduce >> >> memory >> >> requirements. >> >> >> >> Regards, >> >> >> >> Frank >> >> >> >> >> >> >
