Mysql的order by + limit性能优化:
原sql语句如下,在大数据量下(几百上千万),性能非常糟糕。
SELECT *
FROM products
ORDER BY date
LIMIT 0, 10;
SELECT *
FROM products
JOIN (SELECT id
FROM products
ORDER BY date
) AS t ON t.id = products.id
LIMIT 0, 10;