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

[the dragon <ceprn@HOTMAIL.COM>]

Sam,

No.  Just to be on the safe side, I went and added an extra assignment to
blob2.sqr .  both the new sqr and the results (still 13 seconds) are
attached.

clark


----Original Message Follows----

Clark,

Based on your sample programs: blob1.sqr contains an additional assignment
statement ( let #count_in = #count_out) that gets executed once for every
row (i.e. 109135 times!). Could the difference in execution times be partly
attributed to this assignment statement that gets executed so many times? To
properly benchmark this kind of a scenario you should select a scenario that
does not require additional statements like this (between the local and
global procedures) which could give a misleading result!

-Sam Rao



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

blob2.log

blob2.sqr