Hi Daniel,
I disagree with that. Keeping an UDF coded in SQL is better than using "C" because the optimizer merges the SQL with the request. So you get better response time.
HTH,
________________________
Jean-Marc BLAISE
IDB Consulting


> Message du 31/05/06 14:53
> De : "DANIEL CALLAHAN "
> A : "LazyDBA Discussion"
> Copie à :
> Objet : RE: UDF in UDB
>
> If the UDF is SQL, change it to a "C" program.
>
>
>
>
>
>
> "Jayaprakash.Band
> aru "
> > hield-x47773589.x "LazyDBA Discussion"
> [Email Address Removed] <[Email address protected]
> a.com> cc
>
> 05/31/2006 03:22 Subject
> AM RE: UDF in UDB
>
>
>
>
>
>
>
>
>
>
> Any idea about this?
>
> -----Original Message-----
> From: Jayaprakash.Bandaru
> Sent: Wednesday, May 31, 2006 10:40 AM
> To: LazyDBA Discussion
> Subject: UDF in UDB
>
> Hi,
>
> Our dev team is facing some issues with the UDFs. The brief description
> of the problem is given below:
>
> The problem is the amount of data and the frequency that they are
> running this is causing some problems compared with one code that is
> written and is working well for another application team. This team
> uses this called function less frequently and does not have as much data
> that is passed into this function.
>
> Any suggestions are very much appreciated.
>
> Thanks,
> Jayaprakash.
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
> ---------------------------------------------------------------------------------------
> Wanadoo vous informe que cet e-mail a ete controle par l'anti-virus mail.
> Aucun virus connu a ce jour par nos services n'a ete detecte.
>
>
>
>

DB2 & UDB email list listserv db2-l LazyDBA home page