RE: Single record access really required (was RE: Views and Indexes)

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

In stead of the complete record in a data structure you can store the RRN of 
the record in a hidden field.

Using traditional I/O you can use the INFDS, using SQL you can add it as field 
in the result set.

Chain by RRN or FETCH RRN.

Regards,
Carel Teijgeler.

*********** REPLY SEPARATOR  ***********

On 26-7-04 at 11:02 Joe Pluta wrote:

>> From: Booth Martin
>> 
>> Most selections where one chooses a record to work with from a larger group
>> are based upon some sort of subfile program.  When filling the subfile one
>> can add each individual record's datastructure to the subfile record as a
>> hidden field.  Then there is no longer a reason to look up a single record.
>> There are other advantages to this technique, too.
>
>Nice technique, Booth, but it will bite you when you leave the green
>screen.  The overhead of sending a data structure to and from the UI
>server gets VERY costly, especially as the amount of data increases.  It
>can actually be more efficient to simply send the keys and re-CHAIN when
>needed.  It also helps reduce staleness issues. 
>
>As always, it's a business decision.