One crystal report loading very slowly in production.

See more:

ASP.NET

CrystalReports

MVC3

Hi.

For the exsisting asp.net MVC3 web application i have developned new(rpt) Cystal Report and deployed to Development and UAT region. It work great and without taking much time while loading the data.

For Deploying to UAT i just pointed to UAT SQL server for the exsisting Dev region report and it worked very well for large data also.

While deploying to Live region i just pointed to Production(Live) region SQL Server for the Exsisting UAT region report. But in Live region the report takes more than 4 mins to load the data.For Empty report also it takes too much time.

I don' t understamd what is the issue. The slow ness is happinig to new report alone which i have developed and deployed to Production .The other exsisting report are working greatly.


I tried poingting to Live region Data base from Dev region where report is pointing to Live DB here also it is taking too much time.

When i run the SP(used by report) in SQL server it took less than 1 sec to get 500 records.

Could any one please let me know what is the issue?????

To my understanding the problem will be with SQL Live Db only??? I'm i correct?