Do not run them with Activation Group *NEW
Avoid unnecessary ITER operations, create/use a logical file (or better an
SQL Index) with the right sequence and SELECT/OMIT-Clauses or WHERE
conditions.
When using embedded SQL:
Avoid compile option CLOSQLCSR=*ENDMOD
Do not specify DDS described logical files, use SQL views instead
Instead of working with multiple cursors, check whether the files/tables can
be joined together.
Check whether the right indexes are available
Use Multiple Row Fetches into Array Data structures
Avoid SELECT *, only specify the columns/fields you really need
Avoid dynamic SQL (and if you have to use dynamic SQL PREPARE once and
EXECUTE multiple times)
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von RPGLIST
Gesendet: Thursday, 03.1 2013 15:44
An: rpg400-l@xxxxxxxxxxxx
Betreff: Suggestions on Speeding up a program
I'm looking for any and all suggestions on possible ways to speed up some
programs.
The typical ones that come to mind are:
1. avoiding open and closes on files
2. Not setting LR when calling a program or procedure multiple times 3.
using Data structures for block reads and writes
Any other suggestions?
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
