我在MySQL上有一个包含450000条记录的表。下面的查询花费了近 3 秒。是否有可能降低时间成本?
SELECT * FROM table order by id desc limit 400000, 8000
假设id
被索引,那么除了上面建议的内容之外,您无能为力。也就是说,我很惊讶它这么慢...
SELECT COUNT(*) FROM my_table;
+----------+
| COUNT(*) |
+----------+
| 450000 |
+----------+
1 row in set (0.12 sec)
SELECT * FROM my_table ORDER BY i DESC LIMIT 400000,8000;
...
8000 rows in set (0.20 sec)