| 我的报表使用了行式引擎，数据集相对复杂，打开和切换下一页报表时还是很慢，为什么呢？ 我理解的行式引擎报表的使用场景有错误吗？ http://help.finereport.com/doc-view-997.html 行引擎报表:边取数边执行报表，执行到哪页用户就可以看到哪页，用户访问到看到结果的时间=首页数据读取时间+首页计算时间。 SQL: select * from ( SELECT a.id, CASE WHEN a.client_name = '' OR a.client_name IS NULL THEN '--' ELSE a.client_name END AS '客户姓名', CASE WHEN a.card_id = '' OR a.card_id IS NULL THEN '--' ELSE a.card_id END as '证件号码', CASE WHEN a.mobile = '' OR a.mobile IS NULL THEN '--' ELSE a.mobile END as '移动电话', CASE WHEN a.client_type = 0 THEN '意向客户' ELSE '投资客户' END AS '客户类型', CASE WHEN a.register_time = 0 OR a.register_time IS NULL THEN '--' ELSE FROM_UNIXTIME(a.register_time) END as '注册时间', CASE WHEN a.auth_time = 0 OR a.auth_time IS NULL THEN '--' ELSE FROM_UNIXTIME(a.auth_time) END as '认证时间', CASE WHEN a.first_submit_time = 0 OR a.first_submit_time IS NULL THEN '--' ELSE FROM_UNIXTIME(a.first_submit_time) END as '首投时间', CASE WHEN b.realname = '' OR b.realname IS NULL THEN '--' ELSE b.realname END as '顾问姓名', CASE WHEN b.card_id = '' OR b.card_id IS NULL THEN '--' ELSE b.card_id END as '顾问证件号码', a.create_time as '创建时间',e.code, CASE WHEN a.org_id > 0 and e.dr != 1 THEN (select GROUP_CONCAT(`name` ORDER BY `code`) from organization where e.`code` like concat(`code`,'%')) ELSE '--' END as '组织架构' FROM client_base_info as a LEFT JOIN admin as b ON a.admin_id = b.id LEFT JOIN organization as e ON a.org_id = e.id WHERE a.dr != 1 ) x ---------------------------------------------------- 使用到的3个数据表记录数分别为： select count(1) as 记录数 from client_base_info -- 47万条 select count(1) as 记录数 from admin -- 26696条 select count(1) as 记录数 from organization -- 12553条 ----------------------------------------------------- 4个关联字段上都有索引： LEFT JOIN admin as b ON a.admin_id = b.id LEFT JOIN organization as e ON a.org_id = e.id 编辑于 2018-9-5 14:36 |
