RE: system performance

Lois,

The SQL angle has been pretty well covered by others so I'll make a couple of non-SQL related suggestions.

First, look for the use of READE vs. READ. It has made a big difference in some of our programs to make the switch from using READE to using READ and checking the input values with a conditional statement.

Also take a look at any date conversions. While the %Date BIF is nice from experience I can tell you that it will slow your programs down if used a lot. I know, that's a very relative term so you will have to evaluate it for yourself.

Same thing for the MONITOR statement. If the code being monitored encounters errors more often than not you will be better off checking for errors another way if possible.

Saying that the system is 'slowing down' is pretty vague. Do you have any analysis data or research findings (run times, etc.) to help narrow down what you should be looking at?

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Lois Krake
Sent: Saturday, August 29, 2009 8:37 AM
To: RPG programming on the AS400 / iSeries
Subject: system performance

Hi:

I am trying to do research on the impact on system performance using logicals with select-omit criteria(we do not use the DYNSLT keyword) vs. using if statements in the rpg code. I don't know if there is a performance difference but our system is slowing down & I am trying to find reasons. I believe they are the direct result of poor programming techniques & I am trying to identify them.

Lois
--

Privileged and Confidential. This e-mail, and any attachments there to, is intended only for use by the addressee(s) named herein and may contain privileged or confidential information. If you have received this e-mail in error, please notify me immediately by a return e-mail and delete this e-mail. You are hereby notified that any dissemination, distribution or copying of this e-mail and/or any attachments thereto, is strictly prohibited.