UDF performance.

Database
Enthusiast

UDF performance.

I installed the is_integer() UDF from http://www.teradataforum.com/is_integer_01.htm
by Dennis Calkins

this function was installed on a database : dbudfdev
and this is how we write our sql

sel dbudfdev.is_integer(col1)
from devdata.table_name

on some big tables it is taking considerably more time to return the answer set.

is there a way to improve the response time?

Thanks for your help.
1 REPLY
Enthusiast

Re: UDF performance.

ALTER FUNCTION dbudfdev.is_integer EXECUTE NOT PROTECTED;

In NOT PROTECTED mode, the UDF is loaded and executed directly by
the AMP worker threads.

In PROTECTED mode (the default) the UDF is loaded and executed in a special UDF executor process and communicates with the AWT using an IPC mechanism.