March 28, 2002 at 7:43 pm
We are moving from SS7.0 to SS2K. User defined functions could not be written in SS7.0 but we can write them in SS2K.
Now some of our procs call other procs repeatedly to do certain calculations and return single outputs; seem to be good candidates for functions.
My question is: If we take a stored proc and change it into a function without any logic changes, just the changes in the way the input and output declarations etc are made, will this make things any faster for us. Are Functions in any way faster than procs because of the way SS executes them.
March 29, 2002 at 10:04 am
From what I have seen this is a no if the logic does not change. Where your biggest performance gain comes from is being able to use it inline in SELECT code. Thus you do not have to use a cursor to and temp tables to get the same output.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 29, 2002 at 10:10 am
Functions should also save you time in code re-use.
Andy
April 1, 2002 at 2:36 pm
Thanks!
April 1, 2002 at 2:56 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply