对于查询死机的问题，根据你提供的日志请告知几点几分几秒点击功能，几点几分几秒功能正常运行完毕。
从日志看15：00：08开始执行完 SELECT RS_ENROLLLEVEL.RSENROLLLEVELID, RS_ENROLLLEVEL.RSENROLLLEVEL 这个SQL后，没有看到与服务器交互，一直到15：00：23才开始执行 SELECT RS_DEPT.RSDEPTID, RS_DEPT.RSDEPT
FROM RS_DEPT 不知道中间在做啥，检查一下客户端逻辑
14：59：22 发了一个 SELECT RS_EMPLOYEETRAINRECORDATION1.RS_TR_YEAR, RS_EMPLOYEETRAINRECORDATION1.RS_TP_LEVEL, RS_EMPLOYEETRAINRECORDATION1.RS_TR_PLANNO, RS_EMPLOYEETRAINRECORDATION1.RS_TR_TRAINDETAIL, RS_EMPLOYEETRAINRECORDATION1.RS_TR_UNDERTAKER, RS_EMPLOYEETRAINRECORDATION1.RS_TR_CONSIGNTRAINTYPE, RS_EMPLOYEETRAINRECORDATION1.RS_TR_TRAINTYPE, RS_EMPLOYEETRAINRECORDATION1.RS_TR_STUDYTYPE, RS_EMPLOYEETRAINRECORDATION1.RS_TR_STARTDATE, RS_EMPLOYEETRAINRECORDATION1.RS_TR_ENDDATE, RS_EMPLOYEETRAINRECORDATION1.RS_TR_STUDYTIME, RS_EMPLOYEETRAINRECORDATION1.RS_TR_SALARY, RS_EMPLOYEETRAINRECORDATION2.RSEMPLOYEEID, RS_EMPLOYEETRAINRECORDATION2.RSEMPLOYEENAME, RS_EMPLOYEETRAINRECORDATION2.RS_TR_STUDYTIME, RS_EMPLOYEETRAINRECORDATION2.RS_TR2_CHARGE, RS_EMPLOYEETRAINRECORDATION2.RS_TR2_REMARK, RS_EMPLOYEETRAINRECORDATION2.RS_TR2_GRADE
FROM RS_EMPLOYEETRAINRECORDATION1 inner join RS_EMPLOYEETRAINRECORDATION2
on RS_EMPLOYEETRAINRECORDATION1.RS_TR_YEAR = RS_EMPLOYEETRAINRECORDATION2.RS_TR_YEAR and RS_EMPLOYEETRAINRECORDATION1.RS_TR_PLANNO = RS_EMPLOYEETRAINRECORDATION2.RS_TR_PLANNO
where RS_EMPLOYEETRAINRECORDATION2.RSEMPLOYEEID in (select RSEMPLOYEEID from RS_QUALIFICATION)
一直到15：00：05分，客户端才收到服务端的返回，这需要检查服务端的情况，即表中数据，如果很多，是否创建了索引啥的，
楼主，参考一下这个帖子 http://bbs.justep.com/forum.php?mod=viewthread&tid=21513 这个分析一下吧 |
发表于 2010-10-11 21:58:18
楼主