最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

TempDB, SrsReportDataProviderPreProcessTempDB And long Running Report Dynamics 365 Finance and operations /TempDB, SrsReportDataProviderPreProcessTempDB 与 Dynamics 365 财务和运营中的耗时报表

网络文摘 alirazazaidi 577浏览 0评论
Recently I got interesting issue. I developed the report based on RDP Class. I have to populate temp table. And based on this temp table I have to aggregate some calculation like sum, Average on Group by. But when I populate another table based on this aggregation. Report starts to go long awaiting state. I dont know the reason. Later I found that I did not give active connection to temp table variables. I added following line of code in reports and report processing reduce to less then 2 minutes this.takeOwnershipOfTempTable(_BEGroupWiseSalarySheetTmp); this.takeOwnershipOfTempTable(_BEBranchWiseSalarySheetTmp);
发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址