【结帖】用SystemMonitor.exe跟踪为什么执行那么多sum和count的SQL？**

bfaomei

如题，，请问如何设置不执行这些，我们现在程序运行的速度好慢好慢！！！希望帮忙解决一下！

jiahaiminghr

需要确定一下，这些语句都是哪些功能发出的！

bfaomei

我们也不知道。。我们没有写这些sql语句,,
如：
SELECT Sum(AUDIT_AMT), Sum(CHECK_AMT1), Sum(CONFIRM_AMT), Sum(REQUEST_QTY) FROM (select fun_get_busstype(BUSS_CUST_CODE) AS BUSS_LEVEL, FEE_DETAIL.REQUESTER_CODE, FEE_DETAIL.REQUEST_QTY, FEE_DETAIL.DISTRICT_CODE, FEE_DETAIL.AREA_CODE, FEE_DETAIL.SUB_AREA_CODE, FEE_DETAIL.BONUS_IN, FEE_DETAIL.MODUALID, FEE_DETAIL.STAUS, FEE_DETAIL.CHECK_AMT1, FEE_DETAIL.CHECK_REMARK1, FEE_DETAIL.AUDIT_AMT, FEE_DETAIL.AUDIT_REMARK, FEE_DETAIL.CONFIRM_AMT, FEE_DETAIL.CONFIRM_REMARK, FEE_DETAIL.FEE_TYPE, FEE_DETAIL.PROJ_NAME, FEE_DETAIL.EXPECT_TARGET, FEE_DETAIL.FEE_NO, FEE_DETAIL.BUSS_CUST_NAME, FEE_DETAIL.BUSS_CUST_CODE, FEE_DETAIL.ENTRY_NO, FEE_DETAIL.AREA_NAME, FEE_DETAIL.REQUESTER_NAME from FEE_DETAIL where FEE_DETAIL.MODUALID = 17) A76545165727349F6998BFDD54CFC8

SELECT Count(*) FROM (select fun_get_busstype(BUSS_CUST_CODE) AS BUSS_LEVEL, FEE_DETAIL.REQUESTER_CODE, FEE_DETAIL.REQUEST_QTY, FEE_DETAIL.DISTRICT_CODE, FEE_DETAIL.AREA_CODE, FEE_DETAIL.SUB_AREA_CODE, FEE_DETAIL.BONUS_IN, FEE_DETAIL.MODUALID, FEE_DETAIL.STAUS, FEE_DETAIL.CHECK_AMT1, FEE_DETAIL.CHECK_REMARK1, FEE_DETAIL.AUDIT_AMT, FEE_DETAIL.AUDIT_REMARK, FEE_DETAIL.CONFIRM_AMT, FEE_DETAIL.CONFIRM_REMARK, FEE_DETAIL.FEE_TYPE, FEE_DETAIL.PROJ_NAME, FEE_DETAIL.EXPECT_TARGET, FEE_DETAIL.FEE_NO, FEE_DETAIL.BUSS_CUST_NAME, FEE_DETAIL.BUSS_CUST_CODE, FEE_DETAIL.ENTRY_NO, FEE_DETAIL.AREA_NAME, FEE_DETAIL.REQUESTER_NAME from FEE_DETAIL where FEE_DETAIL.MODUALID = 17) A76545165727349F6998BFDD54CFC8 WHERE FEE_NO = ?

bfaomei

想说明一点就是我们在DataGrid里设置了某些字段为合计汇总的。。然后它就会现现sum咯。而且是重复了几遍执行了sum语句。比如我设置了四个字段的汇总合计，那么在SystemMonitor跟踪出来的结果就会有8句sum的sql。。耗了也不少时间。另外。count的语句是每进入一次就执行两遍。。搞不懂为什么要执行这些语句？？？？sum的不设置汇总合计就不会出来

alang

检查一下是否在DataGrid上定义了页脚合计之类了

bfaomei

最初由 bfaomei 发布
[B]如题，，请问如何设置不执行这些，我们现在程序运行的速度好慢好慢！！！希望帮忙解决一下！ [/B]

所有功能都有

bfaomei

就是有定义页脚合计啊。。为什么定义了以后就要用sql去算的呢？

bfaomei

最不可思议的是，我一个DataGrid里有四个它段定义了页脚合计。为什么要执行8个sum语句呢？？要是真要用sql去算。那也是执行一次就OK了呀！！

bfaomei

ding。。帮忙看看！！

bfaomei

急啊！！能不能告诉我们什么原因！