Hi, I had a similar issue in the past that I overcome by having the servlet start a separate thread that was producing the report, And a jsp page refreshing every 10 seconds or so checking for completion. Philippe
-----Original Message----- From: Abh N [mailto:[EMAIL PROTECTED] Sent: 19 July 2006 08:17 To: Tomcat Users List Subject: Re: Intermediate write in JSP 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! --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
