开发者

SSRS 2005 Subreporting Performance Concern

开发者 https://www.devze.com 2023-01-17 13:05 出处:网络
I have a report which, when rendered on its own, has the following performance times (taken from ExecutionLogStorage 开发者_高级运维table):

I have a report which, when rendered on its own, has the following performance times (taken from ExecutionLogStorage 开发者_高级运维table):

TimeDataRetrieval:  6776
TimeProcessing:  142
TimeRendering:  30

When this report is used as a sub-report which is repeated 34 times, the performance of the overall report comes out as follows:

TimeDataRetrieval:  9255
TimeProcessing:  187709
TimeRendering:  35

Furthermore, the memory consumption of my IIS process (using ReportViewer web control) goes up by several hundreds of MB.

Are these performance issues inherent to sub-reporting or is there something wrong with my report?

0

精彩评论

暂无评论...
验证码 换一张
取 消