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.
| Author |
Topic |
|
Ex
Posting Yak Master
166 Posts |
 Posted - 2005-11-22 : 17:55:54
|
| Hi all,This is a very simple question just not sure the best approachi want one of my fields to be cacluated depending on another i.e its a units conversion between the 2 fieldsshould i be using some calcuated field ( not sure what to use for this) or a view with a user defined function?------------------------------------------------------------------sp2 for IE is FIREFOX !! |
|
|
Ex
Posting Yak Master
166 Posts |
Posted - 2005-11-22 : 18:26:33
|
| Just an extra question not sure what type of calcuated fields sql server supports but i tried this with a view (i.e have a function on the select statment of my view) seems slow as my converion is a slow function. So i am just wondering if it is slow with a view would it be slow with a calcuated field------------------------------------------------------------------sp2 for IE is FIREFOX !! |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-11-22 : 19:40:46
|
| >>seems slow as my converion is a slow functionI think you have identified the bottleneck, no? If the function is slow, any method you use to call it will still result in slow performance.Why don't you show us your function and an example of how you are calling it? In addition, a brief description of what it is calculating would be helpful. I suspect that you are doing lookups to a table in your function, when JOINS will be much, much more efficient. |
|
|
|
|
|
|
field calcuation