-
January 5th, 2014, 03:36 PM
#1
Stored Procedures of a database, or Table Functions in C#/.NET?
Hello,
I currently use table functions in c#/.net for analytical table operations like aggregation, distribution, allocation, row-wise formulas, subtable transformation, etc.
Once I've implemented a function tree (which represent a quantitative model) using table functions, with data tables as input parameters, I can simulate the whole tree by varying some input values. I use such simulations for scenario analysis and optimizations.
A colleague advised me to use stored procedures instead of table functions for a better performance and scalability.
My first question is, why should I use stored procedures instead of table functions? What are their advantages over table functions?
Second question: Can I find a stored procedure library for analytical table operations?
Selina
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|