Many already know but SQL Server 2005 has released Service Pack 3. Here is the SQL SP3 Bug List. How does this affect MOSS – there is a fix for performance with SQL Reporting Services that run in SharePoint Integrated Mode.
"FIX: Rendering a report is much longer in the SharePoint integrated mode than in the Native mode, especially when you put more than one report viewer Web part on a SharePoint Web page"
A colleague (Steve Mann) stated he did some quick testing that resulted in:
- Direct Report Rendering (clicking on rdl from a reports library) - 70% improvement on initial load; 50%-90% improvement on report refresh
- Report rendering on page with the Report Viewer webpart - only saw a 15% improvement
Do not hold me to these stats. As well reporting services will not always be the performance problem…
However this is a pretty good improvement and you should consider rolling this out.
Posts
2 comments:
Hi Jason,
I can't find "FIX: Rendering a report is much longer in the SharePoint integrated mode than in the Native mode, especially when you put more than one report viewer Web part on a SharePoint Web page" in SQL Service Pack 3 list of bugs. Was it supposed to be in the list?
Thanks,
RDM
Sorry - cannot recall...
Post a Comment