SELECT *
FROM `jtbc_article`
LIMIT 611010 , 30显示行 611010 - 611015 (611,016 总计, 查询花费 0.3408 秒)
--------------------------------------SELECT *
FROM `jtbc_article`
ORDER BY aid DESC
LIMIT 611010 , 30显示行 611010 - 611015 (611,016 总计, 查询花费 2.9877 秒)
--------------------------------------
SELECT *
FROM `jtbc_article`
ORDER BY aid ASC
LIMIT 550050 , 30显示行 550050 - 550079 (611,016 总计, 查询花费 2.4494 秒)
有人告诉我为啥不。有啥优化办法!
FROM `jtbc_article`
LIMIT 611010 , 30显示行 611010 - 611015 (611,016 总计, 查询花费 0.3408 秒)
--------------------------------------SELECT *
FROM `jtbc_article`
ORDER BY aid DESC
LIMIT 611010 , 30显示行 611010 - 611015 (611,016 总计, 查询花费 2.9877 秒)
--------------------------------------
SELECT *
FROM `jtbc_article`
ORDER BY aid ASC
LIMIT 550050 , 30显示行 550050 - 550079 (611,016 总计, 查询花费 2.4494 秒)
有人告诉我为啥不。有啥优化办法!
FROM `jtbc_article`
ORDER BY aid DESC
看看结果,这种方式是用不到索引的
EXPLAIN SELECT AID
FROM `jtbc_article`
ORDER BY aid DESC
这种方式是可以用到索引的
FROM jtbc_article
WHERE aID < (
SELECT min( aid )
FROM (SELECT aid
FROM jtbc_article
ORDER BY aid DESC
LIMIT 610980
) AS T )
ORDER BY aID DESC
LIMIT 30 显示行 0 - 29 (30 总计, 查询花费 0.4101 秒)