Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Overhead for Local Modules
jdi, function calls always involve call overhead, however, the
advantages that local function calls provide in code structure probably
make the overhead a wash compared to the structure of the code when the
local functions are not used.
If the same code is necessary at several points in the program then by placing the code in a procedure you add call overhead at each point the procedure is called by but you eliminate the cost of reading and parsing the repeating lines of code.
Plus you benefit on the coding, testing, debugging, and maintenance phases.
IMHO -- Mark D Powell -- Received on Thu Apr 14 2005 - 15:46:27 CDT