> I recently attended a VS2005 road show, they talked about how in SQL
> 2005 the CLR is now supported in stored procedures and triggers. it
> looks like it has real possibilities. the guy created a stored
While this is a real nice thing for interfacing with other systems and
highly complicated procedures, tests here have shown that it's too slow
to be used in time critical (iow constantly used) procedures. "Native"
SQL procedure outperform the CLR version quite a lot.
Re: Performance is slow when calling web services in SQL CLR ... I do this on each call of the Clr routine.... Lastly - do we need to set this property whenever we use web services, not just in sql clr sp? ... We have SQL CLR stored procedures that call web services.... When the web service calls take long then it affects the performance of SQL DB of that sp completely, and slows down other CLR stored procedures.... (microsoft.public.sqlserver.programming)
