if i write a UDF, how do i know whether to compile it or interprete it ?

It depends on what your UDF does. It it does heavy calculations, like UDS, or you need full access to C functions (pointers, ...), you have to use a compiled UDF.

Use interpreted UDFs only for easy tasks, and remember that a compiled UDF is faster than an interpreted one.

If you look into forum archives, you'll find some more information.

Hi

ap