Re: SQL Server and User Defined Functions
From: Patrick Dehne <patr3ck_at_steidle.net>
Date: Wed, 20 Mar 2002 09:23:07 +0100
Message-ID: <a79gtb$llt$00$1_at_news.t-online.com>
Date: Wed, 20 Mar 2002 09:23:07 +0100
Message-ID: <a79gtb$llt$00$1_at_news.t-online.com>
- runstein (runstein_at_biotronik.com):
> Besides the obvious portability issues, could you guys give me your thoughts
> on udf's? Am I being paranoid or are there some real reasons for my
> hesitancy?
Performance can go down if you have a lot of data and long running user defined functions. Consider for example:
select myfunction(namecolumn) from mylargetable
The user defined function is applied for *every* row of the result. Udf's are a good tool, but they have to be applied with care...
-- Patrick Dehne patr3ck_at_steidle.netReceived on Wed Mar 20 2002 - 09:23:07 CET