tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Phil \(waex\)" <philippe.bertr...@waex.com>
Subject RE: Intermediate write in JSP
Date Wed, 19 Jul 2006 06:52:03 GMT
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:viks4tec@yahoo.co.in] 
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
<jmikus@gmail.com> 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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org



 				
---------------------------------
 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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message