Harvinder Singh wrote:
>
> Hi,
>
> This question is with reference to tuning.....Developers are repeatdely
> using same code ( for example if they want to add as second to date ther
> are using like date+1/86400) and they want to use something like following
> function so that they can write addsecond(date) in their code...
>
> function AddSecond(RefDate date) return date
> as
> begin
> return RefDate + 1/86400;
> end;
>
> Issus is now of performance.......it looks like using function is degrading
> the performance ......Does it advisable to use extensive use of UDF in
> code????
>
> Thanks
> --Harvinder
Harvinder,
Functions are used for relatively complicated code. You could say
'well, we use a lot of loops, so why not using function inc(i) which
returns i + 1'. Calling a function means stacking up a few things
(return address, parameters), jumping to an address (which may be
outside of physical memory at this time), popping things out of the
stack, processing, jumping back ... Complicated stuff. Must be worth the
trouble.
Do not believe that by making everything a function it will become more
maintainable. It's very difficult to follow the logic of a program when
every two instructions you have a function call.
--
Regards,
Stephane Faroult
Oriole Ltd
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
