点击流转的时候特别卡

malixin

系统自带的那个流程流转，为啥点击的时候这么卡呢

2020-12-25 08:24:41 [KSQL Time]sql 执行时间：2285ms, ksql:select org.sFID, org.sFName from SA_OPOrg org join SA_OPAuthorize auth on org.sFID like concat(auth.sOrgFID, '%') where org.sValidState=1  and ((auth.sAuthorizeRoleID='95034E18D84C48B3BE5CF4E4FA556602')) order by org.sSequence
2020-12-25 08:24:41 [Action Time]action执行时间：2800ms,/ScienceAndTechnologyInnovationSys/FeedBack/process/Experience/experienceProcess,businessActivity6,advanceProcessQueryAction
2020-12-25 08:24:41 [Action Time]action执行时间：2829ms,/ScienceAndTechnologyInnovationSys/FeedBack/process/Experience/experienceProcess,businessActivity6,externalAdvanceProcessQueryAction
2020-12-25 08:24:50 [SQL Time]sql 执行时间：3810ms, exec KSQL: select SA_DocNameSpace ,SA_DocNode , SA_DocNameSpace.sDisplayName ,SA_DocNameSpace.sUrl,SA_DocNameSpace.sAccessMode,SA_DocNameSpace.sFlag,SA_DocNameSpace.version  from SA_DocNameSpace SA_DocNameSpace OPTIONAL JOIN SA_DocNode SA_DocNode on SA_DocNameSpace = SA_DocNode.sNameSpace where SA_DocNameSpace.sFlag = 1 and SA_DocNode.sFlag = 1 order by SA_DocNameSpace.sDisplayName asc
  --> sql:SELECT  SA_DocNameSpace.sID, SA_DocNode.sID, SA_DocNameSpace.sDisplayName AS sDisplayName, SA_DocNameSpace.SURL AS sUrl, SA_DocNameSpace.SACCESSMODE AS sAccessMode, SA_DocNameSpace.sFlag AS sFlag, SA_DocNameSpace.version AS version FROM SA_DocNameSpace SA_DocNameSpace LEFT JOIN SA_DocNode SA_DocNode ON SA_DocNameSpace.sID = SA_DocNode.SNAMESPACE  WHERE  (SA_DocNameSpace.sFlag = ?) AND (SA_DocNode.SFLAG = ?)   ORDER BY SA_DocNameSpace.sDisplayName ASC
--> binds:[1, 1]
2020-12-25 08:24:50 [KSQL Time]sql 执行时间：3827ms, ksql:select SA_DocNameSpace ,SA_DocNode , SA_DocNameSpace.sDisplayName ,SA_DocNameSpace.sUrl,SA_DocNameSpace.sAccessMode,SA_DocNameSpace.sFlag,SA_DocNameSpace.version  from SA_DocNameSpace SA_DocNameSpace OPTIONAL JOIN SA_DocNode SA_DocNode on SA_DocNameSpace = SA_DocNode.sNameSpace where SA_DocNameSpace.sFlag = 1 and SA_DocNode.sFlag = 1 order by SA_DocNameSpace.sDisplayName asc
2020-12-25 08:24:50 [Action Time]action执行时间：3947ms,/SA/doc/system/systemProcess,mainActivity,commitAttachAction
2020-12-25 08:24:54 [SQL Time]sql 执行时间：3669ms, exec KSQL: select SA_DocNameSpace ,SA_DocNode , SA_DocNameSpace.sDisplayName ,SA_DocNameSpace.sUrl,SA_DocNameSpace.sAccessMode,SA_DocNameSpace.sFlag,SA_DocNameSpace.version  from SA_DocNameSpace SA_DocNameSpace OPTIONAL JOIN SA_DocNode SA_DocNode on SA_DocNameSpace = SA_DocNode.sNameSpace where SA_DocNameSpace.sFlag = 1 and SA_DocNode.sFlag = 1 order by SA_DocNameSpace.sDisplayName asc
  --> sql:SELECT  SA_DocNameSpace.sID, SA_DocNode.sID, SA_DocNameSpace.sDisplayName AS sDisplayName, SA_DocNameSpace.SURL AS sUrl, SA_DocNameSpace.SACCESSMODE AS sAccessMode, SA_DocNameSpace.sFlag AS sFlag, SA_DocNameSpace.version AS version FROM SA_DocNameSpace SA_DocNameSpace LEFT JOIN SA_DocNode SA_DocNode ON SA_DocNameSpace.sID = SA_DocNode.SNAMESPACE  WHERE  (SA_DocNameSpace.sFlag = ?) AND (SA_DocNode.SFLAG = ?)   ORDER BY SA_DocNameSpace.sDisplayName ASC
--> binds:[1, 1]
2020-12-25 08:24:54 [KSQL Time]sql 执行时间：3675ms, ksql:select SA_DocNameSpace ,SA_DocNode , SA_DocNameSpace.sDisplayName ,SA_DocNameSpace.sUrl,SA_DocNameSpace.sAccessMode,SA_DocNameSpace.sFlag,SA_DocNameSpace.version  from SA_DocNameSpace SA_DocNameSpace OPTIONAL JOIN SA_DocNode SA_DocNode on SA_DocNameSpace = SA_DocNode.sNameSpace where SA_DocNameSpace.sFlag = 1 and SA_DocNode.sFlag = 1 order by SA_DocNameSpace.sDisplayName asc
2020-12-25 08:24:54 [Action Time]action执行时间：3688ms,/SA/doc/system/systemProcess,mainActivity,saveAttachAction
2020-12-25 08:24:58 [KSQL Time]sql 执行时间：3496ms, ksql:select org.sFID, org.sFName from SA_OPOrg org join SA_OPAuthorize auth on org.sFID like concat(auth.sOrgFID, '%') where org.sValidState=1  and ((auth.sAuthorizeRoleID='95034E18D84C48B3BE5CF4E4FA556602')) order by org.sSequence
2020-12-25 08:24:58 [Action Time]action执行时间：4034ms,/ScienceAndTechnologyInnovationSys/FeedBack/process/Experience/experienceProcess,businessActivity6,advanceProcessQueryAction
2020-12-25 08:24:58 [Action Time]action执行时间：4067ms,/ScienceAndTechnologyInnovationSys/FeedBack/process/Experience/experienceProcess,businessActivity6,externalAdvanceProcessQueryAction

jishuang

ql 执行时间：3496ms, ksql:select org.sFID, org.sFName from SA_OPOrg org join SA_OPAuthorize auth on org.sFID like concat(auth.sOrgFID, '%') where org.sValidState=1  and ((auth.sAuthorizeRoleID='95034E18D84C48B3BE5CF4E4FA556602')) order by org.sSequence

执行了3秒

malixin

jishuang 发表于 2020-12-25 09:21
ql 执行时间：3496ms, ksql:select org.sFID, org.sFName from SA_OPOrg org join SA_OPAuthorize auth on  ...

这个是系统的sql  为啥这么慢

jishuang

到数据库中执行看看，确认索引都使用了吗？