mysql limit性能问题

2021-07-12 14:46:13

offset大的时候的比较

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