CLR Integration Vs Performance
-
Hi,
I have a stored procedure, which would fire "n" number of queries which have a function call to a UDF which would again call an Assembly.
Using CLR UDFs in queries will slow down the performance??/
-
It depends what you are trying to return - and what kind of operations are being processed in the CLR code.
Are you doing any updates/inserts/deletes?
Are the queries that are ultimately run fairly consistent in what they are doing?
-
If the CLR UDF's don't, firing "n" number of queries certainly may... especially when "n" number of queries are calling UDF's... sounds like lots and lots of RBAR (pronounce "ree-bar" and is a "Modenism" for "Row By Agonizing Row") which would kill the performance of a CRAY.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply