Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ASP.NET Program runs slow, uses IIS instead of Report Server

Hi,

I have an ASP.NET program (Visual Basic.net 2008) that has an embedded Crystal Report (Full V12.2.0.290) and it runs against a large database on my old test server running Windows 2003 (32 Bit) machine in 10 seconds. On my new Production machine with 64 bit Windows 2003 & SQL Server, the same report takes 65 seconds. I have setup a virtual directory for my website and a virtual directory for each report in IIS. I am already using a SQL view in Crystal which significantly sped things up. I have noticed that when I run the SQL Profiler, the test server shows the 'Application Name' as 'Report Server' and on the Production machine it returns IIS as the 'Application Name'. I am running IIS V6.0 and ASP V2.0.50727 (32 bit on both machines). Can anyone please tell me what I may do in order to get my production machine configured correctly.

Thanks!!!,

Glenn

Former Member
Not what you were looking for? View more on this topic or Ask a question