Reporting services native mode Vs Integrated mode

Question

Hi,

We have a SharePoint dashboard running that uses a custom web part to display reporting services reports (configured in native mode). The reports take around 6 seconds to appear and we'd ideally like them to appear faster. 

Can anyone let me know if configuring it in Integrated Mode would make any difference? If yes, could I still continue to use the ASP.Net report viewer control to display the reports in integrated mode?

Thanks!

Answer 1

With Integrate Mode the report rdl are on SharePoint and not in report Database, interact directly with security Trimed of sharepoint permissions.

The fact of being so slow on can be for many reason, the ideal is have a separate structure and application pool, for Reporting Services Integration Mode, verify your SQL query, your cubes and mdx querys to improve performance, normaly render problem are on querys to database.

"SharePoint and SQL Server Reporting Services - Installation and Setup"

http://blogs.msdn.com/sharepoint/attachment/4194088.ashx

http://blah.winsmarts.com/2007-12-SharePoint_and_SQL_Server_Reporting_Services_-_Installation_and_Setup.aspx

Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-b331-132274ae8c84&displaylang=en

Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies

http://www.microsoft.com/downloads/details.aspx?familyid=58EDD0E4-255B-4361-BD1E-E530D5AAB78F&displaylang=en

The first time can take time and you problably will need to warmup the reports, and use some IIS compression to improve your rending problems and other RS and Sharepoint Techinque to improve performance, here some articles...

Planning for Scalability and Performance with Reporting Services

http://technet.microsoft.com/en-us/library/cc966418.aspx

Tune Web server performance (Office SharePoint Server)

http://technet.microsoft.com/en-us/library/cc298550.aspx

---

André Lage Microsoft SharePoint, CRM and Sybase Consultant
Blog:http://aaclage.blogspot.com
Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/