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

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> 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.

Joe