一个水晶报告在生产中加载非常缓慢。 [英] One crystal report loading very slowly in production.

问题描述

嗨。



对于现有的asp.net MVC3网络应用程序，我开发了新的（rpt）Cystal报告并部署到开发和UAT地区。它工作得很好而且在加载数据时没有花费太多时间。



对于部署到UAT，我只是指向UAT SQL服务器以获取现有的Dev区域报告，它非常有用同样适用于大数据。



在部署到Live区域时，我只是指向生存（实时）区域SQL Server的Exsisting UAT区域报告。但是在Live区域，报告需要超过4分钟来加载数据。对于空报告也需要花费太多时间。



我不明白什么是问题。对于我已经开发并部署到Production的新报告，这个问题很慢。其他现有的报告非常有效。





我试图从开发区域开始生活区域数据库，报告指向Live DB，这也需要花费太多时间。



当我运行SP时（使用过）通过报告）在SQL服务器上花了不到1秒的时间就可以获得500条记录。



任何人都可以告诉我这是什么问题????? br />


据我所知，SQL Live Db只会出现问题???我是正确的吗？

解决方案

检查过去的答案，试试Crystal报告&数据库

如何改进X ？ [ ^ ]

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?

解决方案

Check this past answer, Try Crystal reports & database there
How to improve X?[^]

这篇关于一个水晶报告在生产中加载非常缓慢。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！