Re: Avoid java heap space while using iBatis

2008-10-21 Thread Sundar Sankar
he > available set. Let me know your thoughts > > Regards > Ankit > > -Original Message- > From: Larry Meadors [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 21, 2008 8:16 PM > To: user-java@ibatis.apache.org > Subject: Re: Avoid java heap space while using iB

RE: Avoid java heap space while using iBatis

2008-10-21 Thread ankit.khujneri
] Sent: Tuesday, October 21, 2008 8:42 PM To: user-java@ibatis.apache.org Subject: Re: Avoid java heap space while using iBatis Are you really using all 200,000 data points in your graphs or are you summarizing? Can you use SQL to generate summery information and graph that? On Tue, Oct 21, 2008

RE: Avoid java heap space while using iBatis

2008-10-21 Thread ankit.khujneri
, October 21, 2008 8:16 PM To: user-java@ibatis.apache.org Subject: Re: Avoid java heap space while using iBatis Why do you think queryForList in a loop will work better? Larry On Tue, Oct 21, 2008 at 8:30 AM, <[EMAIL PROTECTED]> wrote: > Hi, > > Our project is facing a java heap sp

RE: Avoid java heap space while using iBatis

2008-10-21 Thread ankit.khujneri
Thanks Jiming, This solution looks good.. I will try implement this. Thanks & Regards Ankit From: Jiming Liu [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2008 8:49 PM To: user-java@ibatis.apache.org Subject: Re: Avoid java heap space while using iB

Re: Avoid java heap space while using iBatis

2008-10-21 Thread Jiming Liu
I suggest you can write/dump the records to a temp file and then implement an Iterator to read the record one after another. from the file. Best regards, Jiming Liu On Tue, Oct 21, 2008 at 10:30 PM, <[EMAIL PROTECTED]> wrote: > Hi, > > Our project is facing a java heap space issue while fetchi

Re: Avoid java heap space while using iBatis

2008-10-21 Thread Michael Schall
Are you really using all 200,000 data points in your graphs or are you summarizing? Can you use SQL to generate summery information and graph that? On Tue, Oct 21, 2008 at 9:45 AM, Larry Meadors <[EMAIL PROTECTED]>wrote: > Why do you think queryForList in a loop will work better? > > Larry > > >

Re: Avoid java heap space while using iBatis

2008-10-21 Thread Larry Meadors
Why do you think queryForList in a loop will work better? Larry On Tue, Oct 21, 2008 at 8:30 AM, <[EMAIL PROTECTED]> wrote: > Hi, > > Our project is facing a java heap space issue while fetching the record set > of around 200,000. > Using a row handler is not helpful as the same record set is b

RE: Avoid java heap space while using iBatis

2008-10-21 Thread kangsin
hi! this might not be your help wanted.. but i think about 200,000 record set...selecting them at once?? will not be a good idea i think.. i have no idea why you are implemented that way and also i suggest you to check your heap profile first just suggesting ... sorry if this doesn't hel