At 10:34 AM 6/28/2001 +0100, Ian Newby wrote:

> Has anyone any information on the relative speed of UDF's verses
>stored procedures? Which one would be best in this instance.

For operations that don't require data access, UDFs are as fast
or faster, particularly when you want to do something like modulo
that is an operator in C and a pain in the ... in stored procedure
language. You have the one time cost of loading the dll library,
but the linkage is quite simple and quick.


Regards,

Ann
www.ibphoenix.com
We have answers.