tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Jouravlev" <jmi...@gmail.com>
Subject Re: Intermediate write in JSP
Date Wed, 19 Jul 2006 05:59:28 GMT
Try setting buffer size to (8x10^6/3x10^4)x500 == 135K.

On 7/18/06, Abh N <viks4tec@yahoo.co.in> 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


Mime
View raw message