Re: Service Program Overhead

[Nathan Andelin <nandelin@xxxxxxxxx>]

James,

I may be able to suggest a few performance tips.  To begin, are you using block(*yes) on the F-spec of your input file?  If not, does that improve performance?

I'd also be interested in hearing the performance difference between reading an SQL "view", rather than your read + chain sequence.

-Nathan.



----- Original Message ----
From: James Perkins <jrperkinsjr@xxxxxxxxx>
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Sent: Fri, November 13, 2009 12:17:12 PM
Subject: Re: Service Program Overhead

David,
I figured it had been discussed before, but I couldn't seem to find
anything. Not that I searching the correct terms mind you ;-)

I'm not doing anything funky in my programs. In fact, I don't turn on LR in
any of the programs. All service programs have an activation group of
*CALLER and the the main program has a *NEW activation group (which is why I
don't turn on LR).

I'm simply reading through a table, chaining to two other tables, escaping
any quotes in the strings and writing the data to a stream file.

I just ran the program twice, once in batch once in interactive, and it took
about 3.5 minutes. Not a lot, but it's about twice as slow as processing in
Java. I just thought it was odd.

Here is a link to some of the supporting code,
http://code.midrange.com/eb5a4923cc.html.

--
James R. Perkins
http://twitter.com/the_jamezp


On Fri, Nov 13, 2009 at 10:55, David Gibbs <david@xxxxxxxxxxxx> wrote:

> I'm sure there is SOME overhead in calling a procedure in a service program
> ... but it's negligible at best (I'm pretty sure this has been discussed
> here or in MIDRANGE-L before).
>
> The majority of code I write these days is almost 80% procedures in service
> programs ... and I haven't had a performance problem at all.
>
> Are you doing anything funky in the service programs ... reclaiming
> activation groups, setting on LR, etc?
>
> How is your service program defined as far as activation groups?  *CALLER,
> named, *NEW?
>
> david
>
> --
> IBM i on Power Systems - For when you can't afford to be out of business
> --
> This is the RPG programming on the IBM i / System i (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.