Re: large difference in job run times between bound procedure call, and procedure call from within program.

To answer your question...

No, a bound procedure call, regardless of rather or not the procedure is
bound by copy (as you've done by including the module in the calling
programs) or bound by reference (by having the module in a service program)
does NOT add that much overhead.

In fact, it should be less overhead than the original CALL PRDALLOC

I suspect your switch to SQL is the issue,
- run your select statement through Visual Explain to see if Db2 has any
recommended indexes.
- ensure that the module is compiled with CLOSQLCSR(*ENDACTGRP)
- show your actual SQL statement for more ideas..

Lastly, I agree with Alan, you should consider having this in a service
program rather than including the module in every calling program.
In that case make sure that the service program is ACTGRP(*CALLER) and that
you're not somehow getting ACTGRP(*NEW) in a loop...

Charles

On Wed, Aug 25, 2021 at 12:59 PM Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>
wrote:

I don't have my terms correct, sorry.

we have many programs that have a sub-routine, called "get allocations".
This routine is found in over a dozen of our programs, and trying to
simplify things, I made it a
procedure, and even migrated from f specs to complete SQL.

However, in a program that invokes this routine 300k times, the run time
went from 25 seconds, to
350 seconds to sometimes over 400 seconds.

If I put the procedure in the bottom of the program I call it, it runs as
fast as the sub-routine call.

maybe this is normal for the overhead of having a bound procedure call, or
maybe I just don't know what i need to do.
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com