单表查询,表中只有27条记录,但是通过FR点击预览的时候,发现报表加载速度还是很慢,分析日志,发现卡在了这里,以下是日志,大家是否有遇到这种情况 2018-12-18 16:23:35 正常:16:23:35 pool-1-thread-1 INFO [root] SQL: SELECT a.stat_time,a.partner_code,a.dd_num,a.m_user_num,a.active_num, CONCAT(ROUND(a.active_num/a.m_user_num*100,2),'%') hyd, a.login_num,CONCAT(ROUND(a.login_num/a.dd_num*100,2),'%') ljdll, a.cm_num, a.cm_active_num, CONCAT(ROUND(a.cm_active_num/cm_num*100,2),'%') cm_active_rate, a.cj_num,CONCAT(ROUND(a.cj_num/a.dd_num*100,2),'%') cjl, a.ts_num,CONCAT(ROUND(a.ts_num/a.dd_num*100,2),'%') tsl FROM dm_sa_b_biz_oldhyb_stock_xy_m a WHERE 1=1 and a.stat_time='201811' 2018-12-18 16:23:37 正常:16:23:37 pool-1-thread-1 INFO [root] 关闭Session:61212 2018-12-18 16:23:45 警告:16:23:45 SocketListener0-2 WARN [com.fr.third.alibaba.druid.pool.DruidDataSource] not full timeout retry : 1 |