新闻公告更多卡死

lqweb

问题：点击更多的时候出现卡死现象，数据库数据量1000多条。不知道是什么问题，原来没有这个情况。是不是数据库问题。

sql：select OA_KM_Knowledge.fTitle as fTitle,OA_KM_Knowledge.fKeyword as fKeyword,OA_KM_Knowledge.fDocNumber as fDocNumber,OA_KM_Knowledge.fImportant as fImportant,OA_KM_Knowledge.fImportantName as fImportantName,OA_KM_Knowledge.fWriter as fWriter,OA_KM_Knowledge.fFolderID as fFolderID,OA_KM_Knowledge.fFolderName as fFolderName,OA_KM_Knowledge.fFolderFullID as fFolderFullID,OA_KM_Knowledge.fFolderFullName as fFolderFullName,OA_KM_Knowledge.fRightsText as fRightsText,OA_KM_Knowledge.fIsNeedApprove as fIsNeedApprove,OA_KM_Knowledge.fContentType as fContentType,OA_KM_Knowledge.fContentTypeName as fContentTypeName,OA_KM_Knowledge.fTemplateID as fTemplateID,OA_KM_Knowledge.fTemplateName as fTemplateName,OA_KM_Knowledge.fLinkURL as fLinkURL,OA_KM_Knowledge.fContentURL as fContentURL,OA_KM_Knowledge.fIsTop as fIsTop,OA_KM_Knowledge.fTopBeginTime as fTopBeginTime,OA_KM_Knowledge.fTopEndTime as fTopEndTime,OA_KM_Knowledge.fCreateOgnID as fCreateOgnID,OA_KM_Knowledge.fCreateOgnName as fCreateOgnName,OA_KM_Knowledge.fCreateDeptID as fCreateDeptID,OA_KM_Knowledge.fCreateDeptName as fCreateDeptName,OA_KM_Knowledge.fCreatePsnID as fCreatePsnID,OA_KM_Knowledge.fCreatePsnName as fCreatePsnName,OA_KM_Knowledge.fCreatePsnFID as fCreatePsnFID,OA_KM_Knowledge.fCreatePsnFName as fCreatePsnFName,OA_KM_Knowledge.fCreateTime as fCreateTime,OA_KM_Knowledge.fReleaseOgnID as fReleaseOgnID,OA_KM_Knowledge.fReleaseOgnName as fReleaseOgnName,OA_KM_Knowledge.fReleaseDeptID as fReleaseDeptID,OA_KM_Knowledge.fReleaseDeptName as fReleaseDeptName,OA_KM_Knowledge.fReleasePsnID as fReleasePsnID,OA_KM_Knowledge.fReleasePsnName as fReleasePsnName,OA_KM_Knowledge.fReleasePsnFID as fReleasePsnFID,OA_KM_Knowledge.fReleasePsnFName as fReleasePsnFName,OA_KM_Knowledge.fReleaseTime as fReleaseTime,OA_KM_Knowledge.fReleaseStatus as fReleaseStatus,OA_KM_Knowledge.fReleaseStatusName as fReleaseStatusName,OA_KM_Knowledge.fApproverID as fApproverID,OA_KM_Knowledge.fApproverName as fApproverName,OA_KM_Knowledge.fApproveTime as fApproveTime,OA_KM_Knowledge.fBizState as fBizState,OA_KM_Knowledge.fBizStateName as fBizStateName,OA_KM_Knowledge.fIsDisplayOnPortal as fIsDisplayOnPortal,OA_KM_Knowledge.fIsInheritRights as fIsInheritRights,OA_KM_Knowledge.fOtherFolders as fOtherFolders,OA_KM_Knowledge.fBizID as fBizID,OA_KM_Knowledge.fBizType as fBizType,OA_KM_Knowledge.fBizTypeName as fBizTypeName,OA_KM_Knowledge.fReaderCount as fReaderCount,OA_KM_Knowledge.fRepliesCount as fRepliesCount,OA_KM_Knowledge.version as version,OA_KM_Knowledge.fPicture1 as fPicture1,OA_KM_Knowledge.fPicture2 as fPicture2,OA_KM_Knowledge.fPicture3 as fPicture3,OA_KM_Knowledge.fPicture4 as fPicture4,OA_KM_Knowledge.fPicture5 as fPicture5,OA_KM_Knowledge.fGZPsnIDs as fGZPsnIDs
    from OA_KM_Knowledge OA_KM_Knowledge
     join OA_KM_Rights OA_KM_Rights on OA_KM_Knowledge.fID = OA_KM_Rights.fKWID
     join OA_KM_KWFolder OA_KM_KWFolder on OA_KM_Knowledge.fID = OA_KM_KWFolder.fKWID WHERE  (OA_KM_Rights.fOrgID='5B1B7C1173EA4834B51713983030B8ED' or (((OA_KM_Rights.fOrgFID = '/750E6E1B1E6A4F0FB9E94969709463CE.ogn')) OR ((OA_KM_Rights.fOrgFID = '/750E6E1B1E6A4F0FB9E94969709463CE.ogn/6B8523C02A634EBE932AACDED2444027.dpt'))) OR ((OA_KM_Rights.fOrgFID = '/750E6E1B1E6A4F0FB9E94969709463CE.ogn/6B8523C02A634EBE932AACDED2444027.dpt/5B1B7C1173EA4834B51713983030B8ED@6B8523C02A634EBE932AACDED2444027.psm'))) and (OA_KM_Rights.fCanReadKW = '1') and ((OA_KM_KWFolder.fKWFullID LIKE 'public/notice%') and (OA_KM_Rights.fKWFullID LIKE 'public/notice%' or OA_KM_Rights.fFolderID IS NULL)) and (OA_KM_Knowledge.fReleaseStatus = 1)

jishuang

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

lqweb

数据库查询也要 10多秒，有的时候又挺快的，只要数据库查询10几秒钟，页面就卡死了。

lqweb

同样的方法，几百条数据就没有问题。

jishuang

如果数据库查询都慢，那是数据库的问题，需要自己优化数据库，可以加索引等