1.问题描述
一个数据查询接口,mapper-xml文件中的分页查询SQL由多张数据表链接查询。当数据表中导入千条左右的数据后,在客户机上执行分页查询时,分页列表十几秒都刷不出来,有时候报链接超时。具体SQL如下:
SELECT
eleDynamic.*,
jwe.supervise,
jwe.flow_ins_id,
jwe.flow_node,
jwe.flow_executor,
jwe.flow_task_id,
PRO.END_TIME_
FROM
ACT_HI_PROCINST PRO
INNER JOIN jg_work_entry jwe ON PRO.PROC_INST_ID_ = jwe.flow_ins_id
INNER JOIN user_define_rk_zdcjsyhhdsj eleDynamic ON eleDynamic.entry_id = jwe.id
WHERE
jwe.pro_id = '1771123199953772545'
AND EXISTS ( SELECT 1 FROM ACT_HI_IDENTITYLINK LINK WHERE USER_ID_ = 'bjsqr' AND LINK.PROC_INST_ID_ = PRO.ID_ AND LINK.TYPE_ = 'assignee' )
AND eleDynamic.NAME LIKE '%十三香%'
ORDER BY
PRO.START_TIME_ DESC;
2.问题排查
2.1.现象
java后端持