Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Mathematical Formulas

Author  Topic 

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-01-09 : 18:42:33
Greetings,

We are trying to create a tool for our Inside Sales based on formulas in the book "Factory Physics". We want to get good performance when doing the maths. Would it be better to use Stored Procedures to do the complex mathematical calculations that will derive values from tables or better use CLR DLL?

Thank you

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2009-01-09 : 21:05:05
According to Microsoft, "A good general rule is that computation- and logic-intensive code is a better choice for implementation in the CLR than is data-access intensive code." There is a detailed discussion of this topic at http://msdn.microsoft.com/en-us/library/ms345136.aspx
Go to Top of Page
   

- Advertisement -