Re: more info - performance with local procedures...

["Johnson, Dan" <Dan_Johnson@WRIGHTEXPRESS.COM>]

Just the kind of response I was hoping to invoke. Sorry about the
'programmer' comment Sam. Unfortunately I am a little green in the real
world as I just graduated last spring. Soon, however, I expect that I will
also forget most of what I learned in school and things like "x$y(x*R *y*R)
will soon mean nothing.

Thanks for the comments, info, and entertaining discussion.
Dan.

        -----Original Message-----
        From:   Sam Spritzer [SMTP:SSpritzer@GW.CTG.COM]
        Sent:   Monday, August 30, 1999 5:50 PM
        To:     Multiple recipients of list SQR-USERS
        Subject:        Re: more info - performance with local procedures...

        a*** r******** programmer?  Boy, am I glad I don't work with you or
better yet, for you.  We are D-E-V-E-L-O-P-E-R-S, pal; programmers have gone
by the way of punchcards and diskpacks.

        SQRly yours,
        Sam

        <<< "Johnson, Dan" <Dan_Johnson@WRIGHTEXPRESS.COM>  8/30  5:11p >>>
                If I learned one thing in school it's this; GLOBAL IS BAD! I
don't
        dispute the possibility that global procedures may be a little bit
slower
        and that if you want to save a few seconds you should write global
code but
        in the meantime you are breaking several rules of the structured
programming
        approach. Here's why you don't want to use global procedures:
        1.      Negates data abstraction
        2.      Drastically Reduces reusability
        3.      Makes code less modular because of the above two problems
        Sure SQR seems to promote the use of global procedures and variables
but it
        is up to you, the anal retentive programmer, to take the path that
leads not
        unto the land of evil globalness but instead take the road less
traveled,
        the road to the land of localness where all is pure and good. (boy,
did the
        grammar check hate that sentence)

        Dan

                -----Original Message-----
                From:   the dragon [SMTP:ceprn@HOTMAIL.COM]
                Sent:   Monday, August 30, 1999 1:30 PM
                To:     Multiple recipients of list SQR-USERS
                Subject:        more info - performance with local
procedures...

                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 <<
File:
        blob1.log >>  << File: blob1.sqr >>  << File: blob2.log >>  << File:
        blob2.sqr >>