You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Michael Lee <ml...@hotmail.com> on 2002/09/06 17:42:36 UTC
Re: [FRIDAY] Out of control ... again [OT] [HELP] [LOTS OF POSTINGS LITTLE HELP]
Hey, do any of you [FRIDAY] guys know how to handle iterating through
enourmously large result sets without storing the ResultSet object in
memory? I use JDBC cursors now but have to do the query upon each 'next' or
'previous'.
I always ask the tough questions that get few responses!
:)
Mike Lee
----- Original Message -----
From: "James Mitchell" <jm...@telocity.com>
To: "Struts Users Mailing List" <st...@jakarta.apache.org>
Sent: Friday, September 06, 2002 11:45 AM
Subject: RE: [FRIDAY] Out of control ... again
> LMAO
>
> James Mitchell
> Software Engineer\Struts Evangelist
> Struts-Atlanta, the "Open Minded Developer Network"
> http://www.open-tools.org/struts-atlanta
>
>
>
>
> > -----Original Message-----
> > From: Chappell, Simon P [mailto:Simon.Chappell@landsend.com]
> > Sent: Friday, September 06, 2002 11:41 AM
> > To: Struts Users Mailing List
> > Subject: RE: [FRIDAY] Out of control ... again
> >
> >
> > Well said Sheriff Eddie!
> >
> > I hereby promise [hand placed upon a stack of printed Struts
> > articles] to be a good Struts mailing list user and to use my
> > power for good and not evil. So help me Craig! :-)
> >
> > Simon
> >
> > -----------------------------------------------------------------
> > Simon P. Chappell simon.chappell@landsend.com
> > Java Programming Specialist www.landsend.com
> > Lands' End, Inc. (608) 935-4526
> >
> >
> > >-----Original Message-----
> > >From: Eddie Bush [mailto:ekbush@swbell.net]
> > >Sent: Friday, September 06, 2002 10:36 AM
> > >To: Struts Users List
> > >Subject: [FRIDAY] Out of control ... again
> > >
> > >
> > >Guys,
> > >
> > >I enjoy (part of) your postings just as much as you intended
> > >them to be
> > >enjoyed. However, it seems we're headed down that dark, lonely
> > >alley-way again. Ok, ok ... I chipped in on the crap myself,
> > >so I guess
> > >I don't have full right to say anything. However, if you
> > >value the list
> > >and wish to see us being able to continue with our "relaxed friday"
> > >attitude, I strongly urge you to cut out the entirely
> > >inappropriate crap
> > >that has started to be slung around today.
> > >
> > >You all know I'm not for cutting out all the [OT] and [FRIDAY] stuff,
> > >but I have to agree with folks that say part of what has been posted
> > >today is uncalled for and entirely inappropriate for public
> > >consumption.
> > >
> > >Bear in mind what we learned from the recent poll:
> > > * Most folks enjoy the [OT] stuff
> > > * Many folks would prefer any [OT] stuff be more closely confined
> > >to technically-oriented topics
> > > * Several would like to make note that beer is not a worthy topic
> > >for discussion
> > >
> > >I think if we keep those points in mind, all of us will be able to get
> > >along just fine. If we find ourselves driven to "think
> > >outside the box"
> > >(wrt these points), I think we'll find that the minority
> > >numbers we saw
> > >dislikeing the [OT] posts will quickly become a majority. Thereafter,
> > >the list will (out of necessity) become much more rigid. I
> > >don't think
> > >any of us want this. Can we *please* act like adults?
> > >
> > >Personally, I enjoyed (a few of) the posts this morning. However,
> > >posting sites with sexually-explicit material - that comes with pop-up
> > >pages of all sorts of things! - and trying to belittle people doesn't
> > >seem appropriate for this list IMNSHO. Many of us are in public areas
> > >where things like the first could get us into serious trouble. The
> > >second is just ... wrong.
> > >
> > >Regards,
> > >
> > >Eddie
> > >
> > >
> > >
> > >--
> > >To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
> >
> > --
> > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
> >
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: [FRIDAY] Out of control ... again [OT] [HELP] [LOTS OF POSTINGS
LITTLE HELP]
Posted by Eddie Bush <ek...@swbell.net>.
PostgreSQL has a nifty bit of functionality for bringing back just
pieces of a result set. You could build something around this
functionality.
I think the pieces of the SELECT you want are:
LIMIT
START
COUNT
Check out their web site.
Regards,
Eddie
(There are other DBMSs that provide this functionality too. Of course,
using something like Jakarta OJB, you could use proxy objects which
would only contain keys and materialize the full objects as you need
them. For a very large result set, however, it may be wiser to go
"database-dependant". Testing both approaches in your application would
be the only way I'm aware of to determine which suits your needs the best)
Bryan Hilterbrand wrote:
>There are many potential solutions to this, but one is to figure out what
>the end result of iterating through your result set is, then create a stored
>procedure to do the same thing.
>
>Bryan
>
>----- Original Message -----
>From: "Michael Lee" <ml...@hotmail.com>
>To: "Struts Users Mailing List" <st...@jakarta.apache.org>
>Sent: Friday, September 06, 2002 9:42 AM
>Subject: Re: [FRIDAY] Out of control ... again [OT] [HELP] [LOTS OF POSTINGS
>LITTLE HELP]
>
>
>Hey, do any of you [FRIDAY] guys know how to handle iterating through
>enourmously large result sets without storing the ResultSet object in
>memory? I use JDBC cursors now but have to do the query upon each 'next' or
>'previous'.
>
>I always ask the tough questions that get few responses!
>:)
>Mike Lee
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: [FRIDAY] Out of control ... again [OT] [HELP] [LOTS OF POSTINGS LITTLE HELP]
Posted by Bryan Hilterbrand <Br...@bullwinkle.net>.
There are many potential solutions to this, but one is to figure out what
the end result of iterating through your result set is, then create a stored
procedure to do the same thing.
Bryan
----- Original Message -----
From: "Michael Lee" <ml...@hotmail.com>
To: "Struts Users Mailing List" <st...@jakarta.apache.org>
Sent: Friday, September 06, 2002 9:42 AM
Subject: Re: [FRIDAY] Out of control ... again [OT] [HELP] [LOTS OF POSTINGS
LITTLE HELP]
Hey, do any of you [FRIDAY] guys know how to handle iterating through
enourmously large result sets without storing the ResultSet object in
memory? I use JDBC cursors now but have to do the query upon each 'next' or
'previous'.
I always ask the tough questions that get few responses!
:)
Mike Lee
----- Original Message -----
From: "James Mitchell" <jm...@telocity.com>
To: "Struts Users Mailing List" <st...@jakarta.apache.org>
Sent: Friday, September 06, 2002 11:45 AM
Subject: RE: [FRIDAY] Out of control ... again
> LMAO
>
> James Mitchell
> Software Engineer\Struts Evangelist
> Struts-Atlanta, the "Open Minded Developer Network"
> http://www.open-tools.org/struts-atlanta
>
>
>
>
> > -----Original Message-----
> > From: Chappell, Simon P [mailto:Simon.Chappell@landsend.com]
> > Sent: Friday, September 06, 2002 11:41 AM
> > To: Struts Users Mailing List
> > Subject: RE: [FRIDAY] Out of control ... again
> >
> >
> > Well said Sheriff Eddie!
> >
> > I hereby promise [hand placed upon a stack of printed Struts
> > articles] to be a good Struts mailing list user and to use my
> > power for good and not evil. So help me Craig! :-)
> >
> > Simon
> >
> > -----------------------------------------------------------------
> > Simon P. Chappell simon.chappell@landsend.com
> > Java Programming Specialist www.landsend.com
> > Lands' End, Inc. (608) 935-4526
> >
> >
> > >-----Original Message-----
> > >From: Eddie Bush [mailto:ekbush@swbell.net]
> > >Sent: Friday, September 06, 2002 10:36 AM
> > >To: Struts Users List
> > >Subject: [FRIDAY] Out of control ... again
> > >
> > >
> > >Guys,
> > >
> > >I enjoy (part of) your postings just as much as you intended
> > >them to be
> > >enjoyed. However, it seems we're headed down that dark, lonely
> > >alley-way again. Ok, ok ... I chipped in on the crap myself,
> > >so I guess
> > >I don't have full right to say anything. However, if you
> > >value the list
> > >and wish to see us being able to continue with our "relaxed friday"
> > >attitude, I strongly urge you to cut out the entirely
> > >inappropriate crap
> > >that has started to be slung around today.
> > >
> > >You all know I'm not for cutting out all the [OT] and [FRIDAY] stuff,
> > >but I have to agree with folks that say part of what has been posted
> > >today is uncalled for and entirely inappropriate for public
> > >consumption.
> > >
> > >Bear in mind what we learned from the recent poll:
> > > * Most folks enjoy the [OT] stuff
> > > * Many folks would prefer any [OT] stuff be more closely confined
> > >to technically-oriented topics
> > > * Several would like to make note that beer is not a worthy topic
> > >for discussion
> > >
> > >I think if we keep those points in mind, all of us will be able to get
> > >along just fine. If we find ourselves driven to "think
> > >outside the box"
> > >(wrt these points), I think we'll find that the minority
> > >numbers we saw
> > >dislikeing the [OT] posts will quickly become a majority. Thereafter,
> > >the list will (out of necessity) become much more rigid. I
> > >don't think
> > >any of us want this. Can we *please* act like adults?
> > >
> > >Personally, I enjoyed (a few of) the posts this morning. However,
> > >posting sites with sexually-explicit material - that comes with pop-up
> > >pages of all sorts of things! - and trying to belittle people doesn't
> > >seem appropriate for this list IMNSHO. Many of us are in public areas
> > >where things like the first could get us into serious trouble. The
> > >second is just ... wrong.
> > >
> > >Regards,
> > >
> > >Eddie
> > >
> > >
> > >
> > >--
> > >To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
> >
> > --
> > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
> >
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>