Hi,

> Hi friends...
> Can someone experienced some perfomence test
> on UDF and SP?
> i.e. It is better to use a complex SP or to write
> a Delphi UDF to manipolate date for example?
> Thanks in advance...

UDFs should NOT be used for manipulating data
in tables. UDFs should only handle stuff that has
nothing to do with a database - like parsing a string,
or mathematics that aren't available in the engine.

UDFs should be non-blocking (no file access) and
thread-safe.



Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."