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
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
转载于:https://my.oschina.net/Jkiss/blog/834118