That's OK if you are loading a subfile from one (master) file. My
experience is that more often than not, there is also business logic
required to determine whether a record should be written to subfile.
This can lead to a big performance overhead using a load-all subfile.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Adams
Sent: 18 February 2010 15:02
To: RPG programming on the IBM i / System i
Subject: RE: "Constant" performance question
Plus isn't it more important that the code be productive from both a
programmer- and user-point-of-view? Unless I find (or have reported to
me) significant issues with performance, I try (not always successfully
it turns out) to write code that (a) the next programmer can most easily
decipher (even though this is a one-man System i-wise shop), and (b)
gives the user/client that easiest path to their objective. Those that
dwell upon nano- or micro-second issues have more important issues that
they need to address.
As an example, the other discussion about subfile performance seems a
little ridiculous to me. On the original AS/400 models there is a
significant difference between page-at-a-time and load-all subfiles. At
least since the Power4 chip the difference is negligible; loading a
1000+ load-all subfile (never had to go the full limit), is still
sub-second response. And, in my opinion, writing a load-all is a heck
of a lot easier to write and understand than a page-at-a-time. Since
it's not a programmer issue, if it ever becomes an issue with the
user/client, I would have to revisit that premise, but a couple of micro
seconds is not something I am going to address.
Jerry C. Adams
IBM System i Programmer/Analyst
--
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Simon Coulter
Sent: Wednesday, February 17, 2010 2:40 PM
To: RPG programming on the IBM i / System i
Subject: Re: "Constant" performance question
On 18/02/2010, at 6:52 AM, Paul Jackson wrote:
if you had to compare a value to
see if it was 0602 multiple times I would expect the named constant to
be more efficient because the system does not have to check each time
for content change unlike with the data structure subfield.
What makes you think the compiler generates code to check if the
content has changed? Surely it would be simpler to just compare
against the current value (changed or otherwise)?
As far as I know there is no difference in efficiency at run-time--and
if there were it would likely be so small as to be truly insignificant
even over multiple iterations.
Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists
http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------
As an Amazon Associate we earn from qualifying purchases.