Hi Ramesh,
I can suggest you some good policies.
1. Use BufferedStreams to write to the file.
2. You can use threads to allow the main servlet to do something while
things are being written.
3. You can make the Query faster using PreparedStatements.
Hope this would be of some help.
Bye,
Jiger
>From: "Ramesh, Kesav" <[EMAIL PROTECTED]>
>Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: need help
>Date: Tue, 9 Jan 2001 22:37:32 -0600
>
>Hi,
>
> In my present project i have a voluminous data of around(3,39,656)
>records
>which i am storing in my webserver's directory as a file and display them
>100 at a time.
>I do have next and previous buttoons on the screen to toggle between the
>next and previous 100 records.
>
>the webserver is in different ip than that of my DB server.I am using
>oracle
>thin client to connect from webserver to DB server.
>
>But this takes a lot of time to write to the file and in the mean time the
>browser gets timed out. I checked with my local set up the file size is
>250mb.
>
>I cannot manipulate with my query since it is formed during runtime.
>
>In my webserver they have set the time as 3 minutes.
>
>any idea to make this happen within 3 minutes???????
>
>i am using jsdk1.0,jdk1.1.7, oracle8i,netscape enterprise server with jrun.
>
>
>Regards
>
>Ramesh Kesavanarayanan
>
>Electronic Data Systems
>Steeple Reach,
>25, Cathedral Road,
>
> 91-44-811 3801 to 15 ext :2186
> 91-44-233 0380 (res)
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
