Subject Re: [ib-support] SP vs. UDF
Author Martijn Tonies

> 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

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

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