Export to PDF performance | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Export to PDF performance

I have a report with several subreports, each one executing a Stored Procedure on the Database, the majority of the reports have charts ont it, and on a P4 1.6Ghz with 512Mb Ram it takes about 10 secs to show the report. But when I export it to PDF it takes 2 to 3 minutes, the aspnet_wp.exe process consumes about 300Mb of memory, and sometimes I get an error because the aspnet_wp.exe process consumes more than 60% of available memory. The result is a 20 pages PDF with 600Kb… My system has: Windows XP sp2
SQL 2000 (8.00.760) sp3a
Visual Studio .Net 2003
Framework 1.1 SP1
Reporting Services Developer Edition Can anyone help? Rui Sousa,