简而言之:一个表有超过1600万条记录[2GB大小].使用ORDER BY*primary_键时,SELECT的限制偏移越大,查询速度越慢*
所以
SELECT * FROM large ORDER BY `id` LIMIT 0, 30
所需时间远低于
SELECT * FROM large ORDER BY `id` LIMIT 10000, 30
That only orders 30 records and same eitherway. 所以 it's not the overhead from ORDER BY.
Now when fetching the latest 30 rows it takes around 180 seconds. How can I optimize that simple query?