Subject Re: [ib-support] SP vs. UDF
Author Helen Borrie
At 01:18 PM 05-06-02 +0000, you wrote:
>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...

It's not a question of "relative performance" - they have quite distinctly
different and non-overlapping usages. Stored procedures manipulate data
for and from database columns, through SQL, and can make use of functions,
both internal and external (UDFs). Functions (including UDFs) *transform*
data and can't perform SQL.


All for Open and Open for All
Firebird Open SQL Database · ·