Thanks Michael ...i will try this option.
I have one more issue.... while looping throught the result set we see the
memory usage increases contineously and then drops (after looping through ~5k)
and then increases again.
Is there any memory managemnt we can do from our side to that it does not
reaches peak limit.
Do I need to run gc after looping for some record set
Michael Jouravlev <[EMAIL PROTECTED]> wrote:
Try setting buffer size to (8x10^6/3x10^4)x500 == 135K.
On 7/18/06, Abh N wrote:
> Hi,
>
> I have requirement where in I have to fetch around 30k (size around 8MB)
> records from DB and render in xls.
>
> I am looping through the result set and then using response.getOutputStream
> for writing the data
>
> The server has a time out of 5min so by the time data gets completely
> rendered server times out
>
> What it did was - Kept a counter , when I am finishing looping thru 500
> records i write to output stream
>
> b=0
> while rs.next {
>
> if(b==500){
> // write to output stream
> b=0
> }
>
> b++
> }
>
> I am able to overcome server time , once the download is complete I am able
> to see only last 500 records
>
> Any suggestion on how to overcome this problem
>
> Thanks
>
>
>
> ---------------------------------
> Find out what India is talking about on Yahoo! Answers India.
> Send FREE SMS from New Yahoo! Messenger to Mobile: Download NOW!
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Find out what India is talking about on Yahoo! Answers India.
Send FREE SMS from New Yahoo! Messenger to Mobile: Download NOW!
