RE: Unlimited size result sets

Oh well, that should be evident by the "proof of concept" that the gal 
wants to try.  Now, if you could just help her out, and she reciprocates 
by trying some of these other suggestions, then you can choose which 
method works best over emotions.

Rob Berendt
-- 
"All creatures will make merry... under pain of death."
-Ming the Merciless (Flash Gordon)




"Haas, Matt" <Matt.Haas@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/18/2003 11:25 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
RE: Unlimited size result sets






This begs the question, who's going to wait around for a quarter million 
rows to be loaded from the database for every request? Regardless of this 
being a servlet or an applet, it's going to take a long time to push that 
much data across a wire (not to mention the amount of memory you'd need 
just to store the data from a single request). If this were only a few 
hundred rows, it wouldn't be much problem but "in the real world", most 
developers are smart enough to let the database do the heavy lifting when 
it comes to selecting and sorting large amounts of data.

Matt

-----Original Message-----
From: Buck [mailto:buck.calabro@xxxxxxxxxxxx]
Sent: Thursday, December 18, 2003 10:52 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Unlimited size result sets


> Get the Java person to make recursive calls to your RPG
> in order to get the dataset(s).

That's the existing situation.  The full scenario is not really an RPG
issue, so I didn't post all the details.  Basically the Java side will be
able to click on a column and sort the dataset in that order.  We RPG folk
want Java to tell us what sort order; we'll return 'one page' of data in
that order.  This means that Java needs to keep track of the last key so 
she
can ask for page 2, etc.

Her contention is that is is better for us to return the entire dataset to
Java, and let her sort it in whatever order she wants.  Management has
tasked me to find a way to give her the entire quarter of a million record
dataset so she can do a proof of concept.
  --buck





_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.