Yes, the resultset beans that I use have a session scope so they are dealt
with when the user either logs out or times out. The problem is one of
scalability. There are a a few resultset beans that could potentially be
quite large. If you multiply this by the number of users on the system at
any time, the memory usage could get out of hand. Being that we are an
underfunded educational institute, it's not likely we're going to get a
memory upgrade for our server any time soon :-)
My 'solution' right now looks something like this. Each resultset bean is
going to be associated with a specific webpage (jsp). I will have a section
of code at the beginning of every jsp in the site that checks the name of
the current jsp page and deletes any resultset beans that are not associated
with the current page. I will just <jsp:include> this source at the
beginning of each page which isn't that big an issue since I'm including
lots of small files in every page anyway (to create formatting tables,
headers, etc).
Thanks to everyone who offered their thoughts on this.
Donald
----- Original Message -----
From: "Kirkdorffer, Daniel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 31, 2000 7:47 PM
Subject: Re: Returning large resultsets
>
>
> Donald,
>
> If you establish a session for each user then when the session times out
you
> can destroy any latent objects tied to it, such as a data bean.
>
> Dan
> --
> Daniel Kirkdorffer
> NACN IS: 425-580-6225
> Sr. Consultant, Syllogistics LLC
> Email: [EMAIL PROTECTED]
> Web: http://www.syllogistics.com/
>
>
> > ----------
> > From: Donald E. Vandenbeld[SMTP:[EMAIL PROTECTED]]
> > Reply To: Donald E. Vandenbeld
> > Sent: Monday, March 27, 2000 6:58 AM
> > To: [EMAIL PROTECTED]
> > Subject: Returning large resultsets
> >
> > I have a question about implementation that I'd love some input on.
> >
> > The Problem:
> > I have a web application that has to return variable length resultsets,
> > sometimes quite large (a few 100 rows max). There are several tables
that
> > might return large resultsets and each gets viewed in a different area
of
> > the website. I need an efficient way to allow a user to navigate
through
> > these resultsets.
> >
> > What I'm doing right now is instantiating a Bean to perform the query
and
> > store the resultset. The controller then passes off to a jsp that
> > displays
> > the first x elements of the resultset vector. Clicking a next/previous
> > button goes forward and back through the set. The problem with this
> > method
> > is that there is not elegant way of disposing of the bean when the user
> > navigates to another part of the website. If there are several of these
> > resultset beans hanging around it leads to a lot of wasted memory.
> >
> > If anyone has some insights they would care to share, I'd greatly
> > appreciate
> > it.
> >
> > Donald
> >
> >
==========================================================================
> > =
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
