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

[rob@xxxxxxxxx]

I think your last paragraph delves more into the detail you are striving
with your website.
In this case he accessed several files with one sql statement.  Now, is
that still slower than the three chains in your example?
Whether or not it is less visibly consistent, or more complex, is in the
eyes of the beholder.  I thought his was quite clear.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com


|-----------------------------+-------------------------------------------|
|   "Joe Pluta"               |                                           |
|   <joepluta@xxxxxxxxxxxxxxxx|                                           |
|   m>                        |                                         To|
|   Sent by:                  |                                    "'Midra|
|   midrange-l-bounces@midrang|                                    nge    |
|   e.com                     |                                    Systems|
|                             |                                    Technic|
|   07/26/2004 04:41 PM       |                                    al     |
|                             |                                    Discuss|
|         Please respond to   |                                    ion'"  |
|         Midrange Systems    |                                    <midran|
|       Technical Discussion  |                                    ge-l@mi|
|      <midrange-l@xxxxxxxxxxx|                                    drange.|
|                m>           |                                    com>   |
|                             |                                         cc|
|                             |                                           |
|                             |                                    Subject|
|                             |                                    RE:    |
|                             |                                    Single |
|                             |                                    record |
|                             |                                    access |
|                             |                                    really |
|                             |                                    require|
|                             |                                    d (was |
|                             |                                    RE:    |
|                             |                                    Views  |
|                             |                                    and    |
|                             |                                    Indexes|
|                             |                                    )      |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|-----------------------------+-------------------------------------------|






> 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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.