报告生成时间增加 [英] Report Generation Time Increases

问题描述

我创建了一个报告，当我第一次开始运行它时，它很快很快，几天就可以了，但是后来，当我运行相同的报告时，它花费了大约15分钟，后来时间又增加了，之后，我在表上创建了索引，并且生成时间减少到了不到2分钟，然后时间又增加了，我对其进行了相同数量的数据测试，而我是唯一运行它的人，为什么会这样呢?有什么强烈的理由，我是唯一访问服务器的人，但是我仍然没有得到它，任何人都可以帮助我吗?

hi i created a report and when i start running it for the first time it is fast it wqas fine for couple of days but later on when i run the same report it took like 15 min and later on the time went up , after that i created indexes on table and the genaration time went down to less than 2 min and later on the time went up , i tested it for same amount of data ,and i am the only one who run it , why is this happening is there any strong reason , i am the only one who access the server ,but still i dont get it , can any one help me out thanks

推荐答案

我认为你有服务器出现问题，可能是连接，游标，打开的连接或处理器，内存等问题.
尝试手动在SQL中运行查询并检查执行计划"

I think you have problems with your server, it could be with the joins, cursors, open connections, or processor, ram, etc.
Try to run the query in SQL manually and check the "Execution Plan"

这篇关于报告生成时间增加的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！