这个警告怎么处理： [com.justep.system.data.impl.TableUtilsImplement]...

ecoolper

<actions><action process="/SA/OPM/system/systemProcess" activity="mainActivity" name="getSysParamsAction" execute-context="" content-type="application/xml"><parameters/></action></actions>
2023-04-02 22:02:27 [catalina-exec-199] [com.justep.system.data.impl.TableUtilsImplement] WARN: queryLimit: 10000, exec KSQL: select pm.sFID AS pm_fid,pm.sFName AS pm_fname,pm.sFCode AS pm_fcode, r, r.sCode as r_sCode, r.sName as r_sName, perm1.*  from SA_OPOrg pm  OPTIONAL JOIN SA_OPAuthorize au ON pm.sFID like concat(au.sOrgFID, '%')  JOIN SA_OPRole r ON (au.sAuthorizeRoleID=r AND r.sValidState = 1)  OPTIONAL JOIN SA_OPPermission perm1 ON (perm1.sPermissionRoleID=r  and perm1.sValidState=1)  WHERE pm.sValidState=1 and pm.sPersonID=:personId and pm.sOrgKindID=:kind
--> sql:SELECT  pm.sFID AS pm_fid, pm.sFName AS pm_fname, pm.SFCODE AS pm_fcode, r.sID, r.SCODE AS r_sCode, r.SNAME AS r_sName, perm1.sID AS perm1, perm1.sPermissionRoleID AS sPermissionRoleID, perm1.SPROCESS AS sProcess, perm1.SACTIVITYFNAME AS sActivityFName, perm1.SACTIVITY AS sActivity, perm1.SACTIONSNAMES AS sActionsNames, perm1.SACTIONS AS sActions, perm1.SSEMANTICDP AS sSemanticDP, perm1.SPERMISSIONKIND AS sPermissionKind, perm1.SDESCRIPTION AS sDescription, perm1.SSEQUENCE AS sSequence, perm1.SVALIDSTATE AS sValidState, perm1.VERSION AS version FROM SA_OPOrg pm LEFT JOIN SA_OPAuthorize au ON pm.sFID LIKE au.SORGFID || ? JOIN SA_OPRole r ON  (au.sAuthorizeRoleID = r.sID) AND (r.SVALIDSTATE = ?)  LEFT JOIN SA_OPPermission perm1 ON  (perm1.sPermissionRoleID = r.sID) AND (perm1.SVALIDSTATE = ?)   WHERE  (pm.SVALIDSTATE = ?) AND (pm.SPERSONID =  ? ) AND (pm.SORGKINDID =  ? )
--> binds:[%, 1, 1, 1, wXtU4vHbY84oxSHJMNP, psm]
--> dataModel|M|/system/data
--> fnModelnull
java.lang.RuntimeException: queryLimit: 10000, ksql: select pm.sFID AS pm_fid,pm.sFName AS pm_fname,pm.sFCode AS pm_fcode, r, r.sCode as r_sCode, r.sName as r_sName, perm1.*  from SA_OPOrg pm  OPTIONAL JOIN SA_OPAuthorize au ON pm.sFID like concat(au.sOrgFID, '%')  JOIN SA_OPRole r ON (au.sAuthorizeRoleID=r AND r.sValidState = 1)  OPTIONAL JOIN SA_OPPermission perm1 ON (perm1.sPermissionRoleID=r  and perm1.sValidState=1)  WHERE pm.sValidState=1 and pm.sPersonID=:personId and pm.sOrgKindID=:kind
        at com.justep.system.data.impl.TableUtilsImplement.queryWarn(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at com.justep.system.opm.Operator.loadActionPermission(Unknown Source)
        at com.justep.system.opm.Operator.loadPersonPermission(Unknown Source)
        at com.justep.system.opm.Operator.<init>(Unknown Source)
        at com.justep.system.opm.OrgUtils.login(Native Method)
        at com.justep.system.opm.OrgUtils.login1(Unknown Source)
        at OPMProcedure.login(OPMProcedure.java:193)
        at OPMProcedure.ntLogin(OPMProcedure.java:174)

jishuang

http://bbs.wex5.com/forum.php?mo ... page=1#pid165647511

ecoolper

结帖

ecoolper

这个问题是否可以优化，每次获取1万条数据，数据量太大，不太合理