Wayne Snyder posted on January 27, 2011 13:58
One of my friends and co-workers has been working on an SSRS in Sharepoint Integrated mode problem. Melissa Coates has an excellent
blog post which details the issues. Derek Sanderson also has a
blog post about this issue.The short version is that images in reports in Sharepoint Integrated Mode can cause the report to run much more slowly than we though. Think about a scorecard with the small images related to good, bad, growing, slowing etc. Each one of those images is a separate http Get - another round trip. In her example, Melissa has a dashboard type report which runs .5 seconds in native mode, and about 11 seconds in integrated mode.
Do some testing to ensure there are no surprises in your SSRS Sharepoint Integrated Mode installation.
To Melissa and others on her team who worked on this - great job!
We are going to follow up with more testing around this.... and we'll post the results.