Re: DDM file performance issue

[Nathan Andelin <nandelin@xxxxxxxxx>]

If by chance you could read a single "join" file rather than do an extra
chain, I bet that would improve performance.

On Fri, Mar 6, 2020 at 2:08 PM ~TA~ <tadair@xxxxxxxxxxxxxxxx> wrote:

> I'm not sure if this is an RPG issue or not, so I plan to cross-post it.
>
> I have an RPGLE program that reads a DDM file (Input Primary) and
> outputs (write/update) to a local DB file.  This has been working fine
> for over a year.  Now I need data from a second DDM file (same
> location), so I added a chain to that file in the program.
> Here's the problem - before, the job took a total of around 35 minutes.
> Now, simply adding a chain to a 2nd DDM file has increased the run time
> to almost 3 hours.
>
> How can adding a single chain to another DDM file increase run time 5x ?
>
> One DDM good, two DDM bad?
>
> I'm also going to post this in Midrange in case it's not an RPG issue.
> (Sorry David, I'm not sure.)
>
> Thanks.
>
> ~TA~
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com