SELECT * FROM persons LIMIT 200000,10;
耗时0.078s
SELECT *
FROM persons WHERE id>=(
SELECT id FROM persons
ORDER BY id LIMIT 200000,1
) LIMIT 10
耗时0.109s
mysql limit性能问题,布布扣,bubuko.com
原文：http://www.cnblogs.com/usual2013blog/p/3721804.html