Try setting buffer size to (8x10^6/3x10^4)x500 == 135K.
On 7/18/06, Abh N <[EMAIL PROTECTED]> 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]
