Should I use "User Defined Functions" in SQL server, or C#?
Posted
by sanity
on Stack Overflow
See other posts from Stack Overflow
or by sanity
Published on 2010-04-28T22:47:37Z
Indexed on
2010/04/28
22:57 UTC
Read the original article
Hit count: 163
I have a fairly complicated mathematical function that I've been advised should be implemented as a User Defined Function in SQL Server so that it can be used efficiently from within a SQL query.
The problem is that it must be very efficient as it may be executed thousands of times per second, and I subsequently heard that UDFs are very inefficient.
Someone suggested that I could implement the function in C# instead, and that this would be much more efficient.
What should I do?
© Stack Overflow or respective owner