Mysql分页优化

WEB系统使用的分页,存在着不定因数.

各种查询条件和随时看任意页.

 

优化前:

SELECT * FROM member LIMIT 193520,10;

时间: 0.027s

 

优化后:

SELECT * FROM member WHERE id >= (SELECT id FROM member ORDER BY id LIMIT 193520,1) LIMIT 10;

时间: 0.014s