My next thought would be another vote to try Performance Monitor.
From: Dexter Thompson [mailto:dexter.thompson@xxxxxxxxx]
Sent: Friday, October 19, 2018 11:57 AM
Subject: Re: RPG and SQL
A very reasonable suggestion. I have already done this however and no
On Fri, Oct 19, 2018 at 10:45 AM Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
I would definitely run this thru Visual Explain and create theseconds/minutes.
recommended index(es). It could improve it from minutes/hours to
Maybe not that much, but it should help.
If the system already has an access path, that can speed up execution.
I can't imagine that would cause it to jump, apparently randomly,
between minutes and hours to execute.
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate