我怎样才能用php强制一个sql查询,跳过读60000行!我只需要选择前10行,这需要一生!
SELECT * FROM `tbl_premium_articles` ORDER BY `id_p` DESC LIMIT 10
有没有办法在一秒钟内把它带过来?
ffscu2ro1#
对于此查询:
SELECT pa.* FROM `tbl_premium_articles` pa ORDER BY pa.id_p DESC LIMIT 10;
你想要索引吗 tbl_premium_articles(id_p) .
tbl_premium_articles(id_p)
1条答案
按热度按时间ffscu2ro1#
对于此查询:
你想要索引吗
tbl_premium_articles(id_p)
.