|

楼主 |
发表于 2018-7-11 10:47:51
|
显示全部楼层
这条sql出现很多次,每次都要1秒以上,这不是启动文档服务器吧
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]
2018-07-11 10:44:30 sql 执行时间:1192ms
|
|