I have an asp.net (VS 2003) app with reports in CR XI . The problem is the performance in the web server. My web server is a Pentium D with 4 Gb RAM - Windows 2003 Server Standard Edition - SQL Server 2000 Standard Edition - IIS 6.0 - .NET Framework 1.1.
The app runs fast but when the user click to view a report, the performance slow down and takes 30-60 seconds to show the Crystal Reports Viewer. I've checked the task manager and the CPU usage for the w3wp.exe processor going to 100% and stay there until the report appear on the viewer!! That is a problem because I have 20-30 users using the app at the same time.
1) How can I reduce this time ?
2) This amount of CPU usage is normal for the w3wp.exe when CR starts the report ?
3) Can I get the report without the viewer ? I tried to export direct to pdf but the time was the same. It's better viewing in the pdf viewer because when paginate, search, etc... the processing is doing on the local machine.
4) Have anyone update to CR XI R2 ? It's faster then CR XI R1 ?
Can anyone help ? Thanks !