more info - performance with local procedures...

[the dragon <ceprn@HOTMAIL.COM>]

Dear gurus, guruettes and lurkers,

Thanks for the feedback I received last week about the performance of local
procedures vs global procedures.  There seem to be some strong feelings
about whether they are good to use of not, with a lot of what I heard being
that local procedures *should* run faster since they are in memory, or
something like that; however, no one cited any real evidence of whether that
was true or not.  So, while I didn't take a lot of time to test this theory
out,  I created a couple of simple programs, blob1.sqr (with a local
procedure) and blob2.sqr (with no local procedure), compiled them and ran
them.  The programs being basically identical, except one procedure is
either local or global, produced the following results:

for 109135 records on an idle RS6000 running Oracle 8,
blob1 (local)       15 seconds
blob2 (global)      13 seconds.

Based upon this very limited data (no significant validity) it appears
global procedures are faster and easier to work with.

I welcome any additional evidence that either supports or debunks this
theory.  please attache code and results in postings - either here or
directly to me.

long life and continued success

clark
dragon enterprises

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

blob1.log

blob1.sqr

blob2.log

blob2.sqr