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

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: CWilt@xxxxxxxxxxxx
> 
> I'm simply showing the select here, not the code to create the
> cursor or do the fetch.  Also, %ifnull(itm.item) is my pseudocode
method
> of
> saying check the null indicator used for the ITEM field returned from
the
> ITM file.

Well, let's see here.

First, you're basically doing all my code plus extra, and you haven't
even shown the rest of the code.  Second, you're doing a select into,
which we've found is much slower than the corresponding CHAIN.  Third,
you don't show the code for the GetSysVal function.  Finally, you're
reading records you may not have to read - in my version, if the IGL
field is non-blank, no other records are read.

Your version is slower, less visibly consistent, more complex, requires
more syntactical knowledge, is less efficient and even takes longer to
compile than my version.  What benefit do you see here? 

Joe