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 |
|
Fletch
Starting Member
29 Posts |
 Posted - 2005-08-12 : 11:45:47
|
| I have a report (two tables + a chart) that uses 7 datasets (1 stored proc per dataset)Having run each of these stored procedures through query analsyer on the same environment and DB and monitored processing time...The sum total of all queries comes to 15 seconds.However, when I run the report it takes a consistent 65 seconds.Where is the other 50 seconds spent? It can't all be on rendering the report? How can I find the missing time!!For every other report I have, the run time is within a second or two of the sum of the stored proc run times.thanks for any help. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-12 : 16:14:52
|
| When you did your timings in QA, did you have "Scroll results as received" checked and perhaps skewed your timings? How many rows are being returned to the Report server? When you run the report, are you doing so in the Preview tab of the designer or on the Report Server directly? Are you rendering in the native Report Server format or rendering to something else such as PDF?---------------------------EmeraldCityDomains.com |
 |
|
|
|
|
|
Where does time go??