Re: Index read performance

Steve,

I think that the index recommendations would not apply in the case of RPG
programs using RLA (opcodes such as SETLL, READ, CHAIN, etc.)

Regards,

Luis

Luis Rodriguez

-- On 28 January 2016 at 09:06, Steve Landess <sjl_abc@xxxxxxxxxxx> wrote:

>"Vinay Gavankar" wrote:

>>

>
>Also, noticed that the READE operation has taken same amount of time in all

>>3 tests, and that time was slightly less than the base SETLL time ( about
>>1.97 ms).
>>

>
>So that should rule out other system activity, I would think.

>>

>
>Maybe one of the SETLL took all the additional time due to some disc

>>issue??
>>

>
>
>Vinay -
>
>You may already know this, but when you run this program with debug turned
>on, IBM i will make recommendations about any indexes needed to improve
>program performance...
>
>Regards,
>Steve
>
>--
>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
>athttp://archive.midrange.com/midrange-l.
>
>Please contactsupport@xxxxxxxxxxxx for any subscription related
>questions.
>

-- 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. Please contact support@xxxxxxxxxxxx for any subscription related questions.