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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2011-04-13 : 06:15:17
|
| Hi All,Can any body please let me know performance based on SSRS report based on stored procedure and report based on sql query.Which is better for ideal situation.T.I.A |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-13 : 07:57:11
|
| Based on an SP will be easier to deal with. Easier to optimise hence performance is likely to be better.Other than that it depnds on the query - if it is static then the plan will be cached the first time it is run should be little difference (there are anomolies so you need to test). If it has parameters and changes each time then the SP might have a performance benefit but that is unlikely to be a major factor.The isolation of the database from the report by using an SP should be the main benefit. I always use SPs for all intereaction to SSRS (caviat - unless a really good reason not to)==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2011-04-20 : 02:37:18
|
| Hi,Can i conclude at one point as The Reporting Server is at all times slower than a DB server. So if we have SSRS is build on DB Server only then there will be least consideration whether to use Stored Procedure or Embedded TSQL.T.I.A |
|
|
|
|
|
|
SSRS report performance