怎么处理概念里左关联的字段作为setFilter的条件

eqwfrfsky

我需要做一个非空过滤，是用当前概念的左关联字段去写setFilter,this.comp("mainData").setFilter("filterzd", "fRKMC is not null");fRKMC就是左关联里的别名，但是非空数据比较大，执行setFilter("filterzd", "fRKMC is not null")然后刷新的时间会很久，页面会卡住10秒，请问怎么解决

jishuang

sql的执行时间打出来看看
http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035

eqwfrfsky

2018-08-15 12:49:02 [SQL Time]sql 执行时间：722ms, exec KSQL: SELECT T_LX_XMLXLZ.*,SA_OPORG.SNAME as XMLXLZCDDW,SA_OPORG_2.SNAME as XMLXLZGKGLDW,SA_OPPERSON.SNAME as XMLXLZFZR,SA_OPPERSON_3.SNAME as XMLXLZBZR,T_ZD_YJXMJHGCZD.FMC as XMLXLZYJXMMC,T_ZD_YJXMJHGCZD_4.FMC as XMLXLZSHJHMC,T_ZD_YJXMJHGCZD_5.FMC as XMLXLZSHGCMC,T_ZD_YS_TYPE.F_YS_TYPE as XMLXLZYSLXMC,SA_OPORG_3.SNAME as XMJSSHJGNAME,SA_OPORG_4.SNAME as XMYSSHJGNAME,SA_OPORG_1.SNAME as XMLXLZJSSHDWMC,T_JH_BZXXZB.fXMMC as SSEJXMNAME,V_SA_TASK_LXLZ_TK_MR.SNAME as JDNAME,V_SA_TASK_LXLZ_TK_MR.TASK_PX as JDPX,T_LX_XMRK.fRKMC as fRKMC  FROM T_LX_XMLXLZ T_LX_XMLXLZ  optional  join SA_OPORG SA_OPORG on SA_OPORG.SCODE = T_LX_XMLXLZ.fXMCDDW optional  join SA_OPORG SA_OPORG_2 on SA_OPORG_2.SCODE = T_LX_XMLXLZ.fGKGLDW optional  join SA_OPPERSON SA_OPPERSON on SA_OPPERSON.SCODE = T_LX_XMLXLZ.fXMFZR optional  join SA_OPPERSON SA_OPPERSON_3 on SA_OPPERSON_3.SCODE = T_LX_XMLXLZ.fYSBZR optional  join T_ZD_YJXMJHGCZD T_ZD_YJXMJHGCZD on T_ZD_YJXMJHGCZD = T_LX_XMLXLZ.fSZYJXM optional  join T_ZD_YJXMJHGCZD T_ZD_YJXMJHGCZD_4 on T_ZD_YJXMJHGCZD_4 = T_LX_XMLXLZ.fSZJH optional  join T_ZD_YJXMJHGCZD T_ZD_YJXMJHGCZD_5 on T_ZD_YJXMJHGCZD_5 = T_LX_XMLXLZ.fSZGC optional  join T_ZD_YS_TYPE T_ZD_YS_TYPE on T_ZD_YS_TYPE.FYSLX = T_LX_XMLXLZ.fYSLX optional  join SA_OPORG SA_OPORG_3 on SA_OPORG_3.SCODE = T_LX_XMLXLZ.fJSSHJG optional  join SA_OPORG SA_OPORG_4 on SA_OPORG_4.SCODE = T_LX_XMLXLZ.fYSSHJG optional  join SA_OPORG SA_OPORG_1 on SA_OPORG_1.SCODE = T_LX_XMLXLZ.fJSSHJG optional  join SA_OPORG SA_OPORG_2 on SA_OPORG_2.SCODE = T_LX_XMLXLZ.fGKGLDW optional  join T_JH_BZXXZB T_JH_BZXXZB on T_JH_BZXXZB.fXMBH = T_LX_XMLXLZ.fSZEJXM optional  join V_SA_TASK_LXLZ_TK_MR V_SA_TASK_LXLZ_TK_MR on V_SA_TASK_LXLZ_TK_MR.SDATA1 = T_LX_XMLXLZ optional  join T_LX_XMRK T_LX_XMRK on T_LX_XMRK.fZBID = T_LX_XMLXLZ WHERE ((T_LX_XMLXLZ.fXMMC is not null)) LIMIT 0, 20
  --> sql:SELECT  T_JH_BZXXZB.FXMMC AS SSEJXMNAME, T_LX_XMLXLZ.FID AS T_LX_XMLXLZ, SA_OPORG_3.SNAME AS XMJSSHJGNAME, SA_OPPERSON_3.SNAME AS XMLXLZBZR, SA_OPORG.SNAME AS XMLXLZCDDW, SA_OPPERSON.SNAME AS XMLXLZFZR, SA_OPORG_2.SNAME AS XMLXLZGKGLDW, SA_OPORG_1.SNAME AS XMLXLZJSSHDWMC, T_ZD_YJXMJHGCZD_5.FMC AS XMLXLZSHGCMC, T_ZD_YJXMJHGCZD_4.FMC AS XMLXLZSHJHMC, T_ZD_YJXMJHGCZD.FMC AS XMLXLZYJXMMC, T_ZD_YS_TYPE.F_YS_TYPE AS XMLXLZYSLXMC, SA_OPORG_4.SNAME AS XMYSSHJGNAME, T_LX_XMLXLZ.FBZND AS fBZND, T_LX_XMLXLZ.FCJR AS fCJR, T_LX_XMLXLZ.FCJSJ AS fCJSJ, T_LX_XMLXLZ.FDBBH AS fDBBH, T_LX_XMLXLZ.FDENJFKZS AS fDENJFKZS, T_LX_XMLXLZ.FDSNJFKZS AS fDSNJFKZS, T_LX_XMLXLZ.FDYNJFKZS AS fDYNJFKZS, T_LX_XMLXLZ.FGKGLDW AS fGKGLDW, T_LX_XMLXLZ.FHTBS AS fHTBS, T_LX_XMLXLZ.FJSSHJG AS fJSSHJG, T_LX_XMLXLZ.FQSND AS fQSND, T_LX_XMRK.FRKMC AS fRKMC, T_LX_XMLXLZ.FRWBSID AS fRWBSID, T_LX_XMLXLZ.FSFDYCTJ AS fSFDYCTJ, T_LX_XMLXLZ.FSZEJXM AS fSZEJXM, T_LX_XMLXLZ.FSZGC AS fSZGC, T_LX_XMLXLZ.FSZJH AS fSZJH, T_LX_XMLXLZ.FSZYJXM AS fSZYJXM, T_LX_XMLXLZ.FXGR AS fXGR, T_LX_XMLXLZ.FXGSJ AS fXGSJ, T_LX_XMLXLZ.FXMBH AS fXMBH, T_LX_XMLXLZ.FXMBS AS fXMBS, T_LX_XMLXLZ.FXMCDDW AS fXMCDDW, T_LX_XMLXLZ.FXMFZR AS fXMFZR, T_LX_XMLXLZ.FXMMC AS fXMMC, T_LX_XMLXLZ.FXMXZ AS fXMXZ, T_LX_XMLXLZ.FXMZJFKZS AS fXMZJFKZS, T_LX_XMLXLZ.FXMZX AS fXMZX, T_LX_XMLXLZ.FYSBZR AS fYSBZR, T_LX_XMLXLZ.FYSLX AS fYSLX, T_LX_XMLXLZ.FYSSHJG AS fYSSHJG, T_LX_XMLXLZ.FZZND AS fZZND, T_LX_XMLXLZ.VERSION AS version FROM T_LX_XMLXLZ T_LX_XMLXLZ LEFT JOIN SA_OPORG SA_OPORG ON SA_OPORG.SCODE = T_LX_XMLXLZ.FXMCDDW LEFT JOIN SA_OPORG SA_OPORG_2 ON SA_OPORG_2.SCODE = T_LX_XMLXLZ.FGKGLDW LEFT JOIN SA_OPPERSON SA_OPPERSON ON SA_OPPERSON.SCODE = T_LX_XMLXLZ.FXMFZR LEFT JOIN SA_OPPERSON SA_OPPERSON_3 ON SA_OPPERSON_3.SCODE = T_LX_XMLXLZ.FYSBZR LEFT JOIN T_ZD_YJXMJHGCZD T_ZD_YJXMJHGCZD ON T_ZD_YJXMJHGCZD.FID = T_LX_XMLXLZ.FSZYJXM LEFT JOIN T_ZD_YJXMJHGCZD T_ZD_YJXMJHGCZD_4 ON T_ZD_YJXMJHGCZD_4.FID = T_LX_XMLXLZ.FSZJH LEFT JOIN T_ZD_YJXMJHGCZD T_ZD_YJXMJHGCZD_5 ON T_ZD_YJXMJHGCZD_5.FID = T_LX_XMLXLZ.FSZGC LEFT JOIN T_ZD_YS_TYPE T_ZD_YS_TYPE ON T_ZD_YS_TYPE.FYSLX = T_LX_XMLXLZ.FYSLX LEFT JOIN SA_OPORG SA_OPORG_3 ON SA_OPORG_3.SCODE = T_LX_XMLXLZ.FJSSHJG LEFT JOIN SA_OPORG SA_OPORG_4 ON SA_OPORG_4.SCODE = T_LX_XMLXLZ.FYSSHJG LEFT JOIN SA_OPORG SA_OPORG_1 ON SA_OPORG_1.SCODE = T_LX_XMLXLZ.FJSSHJG LEFT JOIN SA_OPORG SA_OPORG_2 ON SA_OPORG_2.SCODE = T_LX_XMLXLZ.FGKGLDW LEFT JOIN T_JH_BZXXZB T_JH_BZXXZB ON T_JH_BZXXZB.FXMBH = T_LX_XMLXLZ.FSZEJXM LEFT JOIN V_SA_TASK_LXLZ_TK_MR V_SA_TASK_LXLZ_TK_MR ON V_SA_TASK_LXLZ_TK_MR.SDATA1 = T_LX_XMLXLZ.FID LEFT JOIN T_LX_XMRK T_LX_XMRK ON T_LX_XMRK.fZBID = T_LX_XMLXLZ.FID  WHERE T_LX_XMLXLZ.FXMMC IS NOT NULL
--> binds:[]
2018-08-15 12:49:03 [SQL Time]sql 执行时间：415ms, exec KSQL:
  --> sql:SELECT count(*) FROM T_LX_XMLXLZ T_LX_XMLXLZ LEFT JOIN SA_OPORG SA_OPORG ON SA_OPORG.SCODE = T_LX_XMLXLZ.FXMCDDW LEFT JOIN SA_OPORG SA_OPORG_2 ON SA_OPORG_2.SCODE = T_LX_XMLXLZ.FGKGLDW LEFT JOIN SA_OPPERSON SA_OPPERSON ON SA_OPPERSON.SCODE = T_LX_XMLXLZ.FXMFZR LEFT JOIN SA_OPPERSON SA_OPPERSON_3 ON SA_OPPERSON_3.SCODE = T_LX_XMLXLZ.FYSBZR LEFT JOIN T_ZD_YJXMJHGCZD T_ZD_YJXMJHGCZD ON T_ZD_YJXMJHGCZD.FID = T_LX_XMLXLZ.FSZYJXM LEFT JOIN T_ZD_YJXMJHGCZD T_ZD_YJXMJHGCZD_4 ON T_ZD_YJXMJHGCZD_4.FID = T_LX_XMLXLZ.FSZJH LEFT JOIN T_ZD_YJXMJHGCZD T_ZD_YJXMJHGCZD_5 ON T_ZD_YJXMJHGCZD_5.FID = T_LX_XMLXLZ.FSZGC LEFT JOIN T_ZD_YS_TYPE T_ZD_YS_TYPE ON T_ZD_YS_TYPE.FYSLX = T_LX_XMLXLZ.FYSLX LEFT JOIN SA_OPORG SA_OPORG_3 ON SA_OPORG_3.SCODE = T_LX_XMLXLZ.FJSSHJG LEFT JOIN SA_OPORG SA_OPORG_4 ON SA_OPORG_4.SCODE = T_LX_XMLXLZ.FYSSHJG LEFT JOIN SA_OPORG SA_OPORG_1 ON SA_OPORG_1.SCODE = T_LX_XMLXLZ.FJSSHJG LEFT JOIN SA_OPORG SA_OPORG_2 ON SA_OPORG_2.SCODE = T_LX_XMLXLZ.FGKGLDW LEFT JOIN T_JH_BZXXZB T_JH_BZXXZB ON T_JH_BZXXZB.FXMBH = T_LX_XMLXLZ.FSZEJXM LEFT JOIN V_SA_TASK_LXLZ_TK_MR V_SA_TASK_LXLZ_TK_MR ON V_SA_TASK_LXLZ_TK_MR.SDATA1 = T_LX_XMLXLZ.FID LEFT JOIN T_LX_XMRK T_LX_XMRK ON T_LX_XMRK.fZBID = T_LX_XMLXLZ.FID  WHERE T_LX_XMLXLZ.FXMMC IS NOT NULL
--> binds:[]

eqwfrfsky

如果查的不是左关联的字段就很快

jishuang

你看的是ksql的执行时间，看sql的执行时间

然后用jdbc方式连接数据库用setParameter的方法赋值看执行时间

这个应该需要自己优化数据库