what you say may be correct at times. But i am dead against using the whole
RESULTSET in a session . This is alos not possible since RESULTSET is not
serializable.
But my porblem is that after i write to a file and display 100 i invoke a
unix grep command to find the pattern in the whole file.
This cannot be achived if i write 100 at a time since grep is for the whole
file. so i need a way to write to a file. also file manipulations is faster
than vector manipulations . i cannot think of using something else as i told
you i am using jdk1.1.7 which does not suport linked list and other stuff.
may be you can get me some info from your friends as to how to increase the
performance in this case.
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]
-----Original Message-----
From: Manish, Singh (IE10) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 10, 2001 12:28 PM
To: [EMAIL PROTECTED]
Subject: Re: need help
this is not a proper design basically after fetching all the records you
have the result set the result set sdhould be scrollable , if yu are using
Servlets then show 100 rows at a time and store the REsultSet in the
Session, when the user presses NExt or PRevious scroll accoridnlgy and
dislpay those results,
One thing to keep in mind is that the ResultSet is not Serilizable
but the Servlet Engnies Serilizes the Sessin from time to time, so you will
have to use manual serialization and not Serialize the ResultSet or
another way is to wrap the ResultSet inside some wrapper class and
in that class Keep the ResultSet as a transient Member and you add this
wrapper class to the Session,
Writing to a file is a bad way.
Manish Singh
May the Force be with you
> -----Original Message-----
> From: Ramesh, Kesav [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, January 10, 2001 10:08 AM
> To: [EMAIL PROTECTED]
> Subject: need help
>
> 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
___________________________________________________________________________
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
___________________________________________________________________________
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
