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