分页优化

一、传统分页

Select * from table limit 10000,10;

二、LIMIT原理

Limit 10000,10 偏移量越大则越慢


三、推荐分页

3.1  

Select * from table WHERE id>=23423 limit 11; #10+1 (每页10条) 
Select * from table WHERE id>=23434 limit 11;

  

3.2

Select * from table WHERE id >= ( select id from table limit 10000,1 ) limit 10;

  

 

3.3

Select * from table INNER JOIN (SELECT id from table limit 10000,10) USING(id)

  

 

3.4

程序取ID: Select id from table limit 10000,10;
Select * from table WHERE ID in(123,456…);

  


posted @ 2018-07-30 19:54 waterystone 阅读(...) 评论(...) 编辑 收藏