I'm having a problem with a CLR stored procedure with which I need some assistance. The problem is not the stored procedure itself, per se, but SQL Server.
Here's what's happening: I have a regular T-SQL stored procedure that generates the necessary data and stores in a #temp table. I then call the CLR stored procedure to operate on the #temp table data. It returns data. The problem is that from the time that I issue the EXEC XXXX to the time it returns is ~27000ms. However, the timing statements I put in the CLR sp indicate only ~300ms. So, there's a ~26000ms discrepancy for which I cannot account. I have no idea what is going on here. I tried deleting the sp and then the assembly and then re-installing the assembly and the stored procedures but to no avail. When I add up all the statements, the whole procedure should take <1 second which is more than acceptable for this instance, but alas it won't return for ~27 seconds. Any suggestions or seen this behaviour before? Thanks, Mike =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
