废话不多说直接上sql
select * from FCRM_AGREEMENT_INFO LIMIT 6666666,10; 耗时8.5s
改进
可以根据索引来limit
select * from FCRM_AGREEMENT_INFO a inner JOIN (select ID from FCRM_AGREEMENT_INFO LIMIT 6666666,10) b on a.ID=b.ID; 耗时1.11s
当然,实际场景用到的很少,基本都会分表分库。
废话不多说直接上sql
select * from FCRM_AGREEMENT_INFO LIMIT 6666666,10; 耗时8.5s
改进
可以根据索引来limit
select * from FCRM_AGREEMENT_INFO a inner JOIN (select ID from FCRM_AGREEMENT_INFO LIMIT 6666666,10) b on a.ID=b.ID; 耗时1.11s
当然,实际场景用到的很少,基本都会分表分库。