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 |
|
jbphoenix
Yak Posting Veteran
68 Posts |
 Posted - 2009-12-23 : 15:12:36
|
| Would a report run faster doing calculations in the dataset with sql OR doing the calculations in the actual report? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-12-23 : 15:28:32
|
| Like Tara says it depends. For example x-y or divides might be ok. but if you are doing some complex calculations then use sql as it is designed for that. also when you mean dataset what do you mean? is it inline SQL in the dataset or stored procedure?<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-12-24 : 01:56:00
|
quote:
Originally posted by jbphoenix
Would a report run faster doing calculations in the dataset with sql OR doing the calculations in the actual report?
Can you post the code that does the calculation?If you are using a cursor/while loop in sql, better you do calculation in the report. Also note that reporting service comes with some in-built functions that make you calculate in a better wayMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Calculation speed