| Author |
Topic |
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
 Posted - 2009-02-23 : 20:46:01
|
| If I run my sql test case under Management Studio it returns a result set in under 1 second. However when I run the report that displays the same data within report manager it takes 26 seconds before the report completes. Is this typical? What takes all the extra time? Is it building the report table and populating results or producing HTML code for example? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-23 : 21:04:23
|
| What are you using as Dataset? |
 |
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2009-02-23 : 21:51:09
|
| Stored procedure that takes under 1 second to run under management studio. If I run the dataset from Visual Studio it also takes under 1 second. If I run the report under VS in preview it takes around 17 seconds while from Report Manager 26 seconds. I am trying to understand the overheads and if this result is expected for my given test case? Ie do I have it setup and configured correctly? |
|
|
|
Cody
Starting Member
24 Posts |
Posted - 2009-02-23 : 21:55:16
|
| That's funny. I have a very similar issue! An SQL query gets returned within a few seconds, but it takes about 1 minute to render. So I was wondering if the rendering is done on the server or on the client. In my case the report does a LOT of grouping by itself, and summarising data ... so I think that has something to do with it. |
|
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2009-02-23 : 23:53:10
|
| Yes, I do also have some groups (grouping is mainly done by the slq) and a few simple iif statements within the report. I am still surprised by the time differences. |
|
|
|
Cody
Starting Member
24 Posts |
Posted - 2009-02-24 : 20:00:32
|
| In my report I have a Table, and in that I have a charts in one of the group columns that track things like "sales history over the past 12 months".I noticed that with no charts it runs quickly, with a chart with about 3 data points it takes a minute to run, if I add up to 12 data points it takes 5-10 minutes to run. It's slower with line charts than bar charts.I have IIf statements inside, I read both sides are evaluated so I change to SWITCH instead but it only made a minimal performance impact.Do you have charts in yours? |
|
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2009-02-24 : 20:21:03
|
| I do not have charts within this particular report, I have.1. One table.2. Report footer has basic info like pagenumber, totalpages, date etc.3. One table details row, this contains a field with an iif statement in one field and an image item in the second field that uses IIS to pull in an external image(local to the PC), this row is collapsed by default.4. Group two with two basic fields from DB, this row is collapsed by default.5. Group one with 9 fields, 8 are basic info from DB, first field is an image item that displays an icon using a switch statement.6. Two title headers. Top header has a reasonably basic expression to display search time range and site name etc. Bottom header is just basic column titles. |
|
|
|
Cody
Starting Member
24 Posts |
Posted - 2009-02-24 : 22:20:49
|
| I have a feeling this has something to do with the images - the report takes a while to process and render in the execution statistics, but it takes F-O-R-E-V-E-R to load up all the little charts.You could try changing your IIFs for SWITCH statements and see if that helps. |
|
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2009-02-25 : 00:12:09
|
| I am not so sure it only has to do with the images or charts, although I am sure it is a factor. I have other reports, which are very basic tables, and the time to render is a lot longer than the time taken to run the SQL. The time to render also seems to be proportional to the amount of data in the report. I would love to hear from someone who knows how this all works and if this is just how it is or if changes can be made to speed it up? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-25 : 10:22:38
|
| its a big factor. once we had a report which took ages to load and that was given to me as a performance optimizartion task. i couldnt find much problem with query as it was rather quick. In end the culprit was usage of lots of images as background imnage for really big tables inside report. removing them changed peformance drastically. |
|
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2009-02-26 : 00:09:14
|
| So if the information is required in the report it sounds like the answer to the question is; thats just the way it is and it cannot be fixed :) If that is the answer then fine, I just needed to know if it was something specific I could be doing wrong. Thanks for your input. |
|
|
|
Cody
Starting Member
24 Posts |
Posted - 2009-02-27 : 02:50:56
|
| Are you doing this on 2005? That's what I use, I'd be interested in your results if you were to test on 2008 - I might be able to T that up next week for my own work. |
|
|
|
|
Report Manager Performance