Re: Performance question using a simple UDF

[a4g atl <a4ginatl2@xxxxxxxxx>]

@Rob

I am using a Declare process reading each record one at a time.

Darryl

On Thu, Apr 19, 2018 at 10:30 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

> Well, when you do a RPG read does it move data into the buffer at *INZSR
> or at each READ?
>
> Perhaps we need to know more about your UDF.  There's a big difference
> between:
>
>      exec sql values MyUdf(...) into :MyVariable;
> outside of any loop
>
> and
>
> exec sql define C1 cursor for select ColA, ColB, ColC, MyUDF(....) from
> Mytable;
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   a4g atl <a4ginatl2@xxxxxxxxx>
> To:     midrange-l@xxxxxxxxxxxx
> Date:   04/19/2018 10:24 AM
> Subject:        Performance question using a simple UDF
> Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
>
>
>
> I am using my first UDF on a single field and the results are good.
>
> But, the performance seems to be poor. The process is a little complex due
> to the file structure. I have a file for the current 3 months of orders.
> There is another file containing the current years records after being
> transferred from the current file and finally another file with the
> previous years data.
>
> There are a total of approximate 400k records in all the files.
>
> I have UNIONed the files.
>
> The question on performance is:
>
> -  Does the system apply the UDF values at program initiation time, like
> *INZSR or simply at the time the record is read?
>
> TIA
>
> Darryl Freinkel
> --
> 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: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD
>
>
> --
> 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: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD