MySQL性能优化 - 分页查询越来越慢

2020-6-16 流沙 PHP

正常的sql

select * from bd_user limit 3000000, 20; 

优化的sql

select * from bd_user where id>=3000000 order by id limit 0, 20; 


提高分页效率

发表评论:

Powered by 流沙团

备案号:鄂ICP备15017378号-1