do you agree with me in "using user-defined functions in select query"?

[Sonia]

Hi there....

Do you agree with me in using user-defined functions of SQL server 2000 (any type of function) in select query? Especially when the query should be run under web platform?

I need to know about it as soon as possible

thank you very much

[pclement]

I don't see why they can't be used. That is, unless they respresent business logic, which doesn't belong in the data access layer.

[Sonia]

you are right Paul, but the problem is using u.d.f. in select query slows down
running of it. Especially when your appl. is web- based.

Any way, I'm looking for a guidance which describes the advantages & disadvantages of using u.d.f in web-based applications.

Thank u

[P.H.P]

I think these kind of functions will slow down the system , this is a performance problem , but on another side , UDF is have good security specially against SQL Injection if you use it very will

[pclement]

Any way, I'm looking for a guidance which describes the advantages & disadvantages of using u.d.f in web-based applications.
Thank u

If you have to manipulate the data it's likely to be faster on the database server end than on the web server side. Once the data is returned in a Recordset (or whatever type of object you are using) there is more overhead involved in accessing the data.

One of the disadvantages is that UDFs are typically database specific. So, if you're planning on migrating to another database type, and you have UDFs, they would probably need to be rewritten.