Slow PDF and Excel rendering -- sql server reporting services

sql server reporting services : Slow PDF and Excel rendering

Rodrigo Sánchez
10/6/2004 5:01:50 PM

I have a report which is very slow to render on pdf format, is there a way
to help RS speed up the rendering in this formats?
Its a long report and contains embeded images in page headers, has anyone
experienced slow performance when rendering, any dos and donts?
thanks in advance

Ravi Mumulla (Microsoft)
10/7/2004 6:31:39 AM

Did you upgrade to SP1? PDF performance enhancement was a part of SP1
release.

--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view]

Rodrigo Sánchez
10/7/2004 9:46:34 AM

Yes i alredy have SP1 installed
i have a fairly complex report (150-200 pages), and when i export to PDF it
takes 100% of the CPU and stays like that, i dont get the PDF and tha
machine becomes unresponsive
"Ravi Mumulla (Microsoft)" <ravimu@online.microsoft.com> escribió en el
mensaje news:uhJZEIHrEHA.3428@TK2MSFTNGP11.phx.gbl...
[quoted text, click to view]

Rodrigo Sánchez
10/7/2004 9:56:43 AM

Rodrigo Sánchez
10/7/2004 9:56:58 AM

JiangZemin
10/8/2004 9:09:03 AM

[quoted text, click to view]

Ive experienced the same thing (with SP1). Reports which take a couple
seconds to render using URL access take far too long (can timeout) to render
in PDF or Excel. The Sql itself completes in less than a second. Using
the Render() API to generate report in HTML has the same problem.

I hope MSFT addresses this problem. This is major issue and is a real
negative in adopting Sql RS as a serious reporting solution.

AndyC
10/20/2004 5:03:02 AM

Just to add to this thread.

I am experiencing this exact same problem (server is reporting services SP1
and a fully patched Win2K/SQL server), I have posted before regarding this
issue and as always there is never a response from Microsoft. In my opinion
there is a very serious weakness in the rendering engine with regards to PDF
and excel which is especially noticeable when generating matrix based reports
with many columns & rows. I often see Microsoft team trying to pin this down
to the complexity of reports. Put simply if a report takes 15 seconds to
render in HTML and an equivalent time to export to XML or CSV then the fact
that exact same report takes hours to render as a PDF/Excel can only be a
weakness in the rendering engine.

[quoted text, click to view]

Emmanuel
1/27/2005 4:49:14 AM

Hello,

I did encounter also performance problem when rendering a simple report into
Excel; the only special feature this list does have, is that it contains
several hyperlinks to other reports. The report can take 1min+ for about 800
lines to render in Excel with CPU 100%.

Curently, this is a major drawback, that prevents me from putting Reporting
Services into production.

BTW, it would be nice to have the possibility of being able to prevent
hyperlinks from showing up into Excel ... it could have been a workaround,
since I do not really need the hyperlinks in Excel, and I strongly suspect it
could help with the performance problem ...

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn