So I have a table that has a little over 5 million rows. When I use SQL_CALC_FOUND_ROWS the query just hangs forever. When I take it out the query executes within a second withe LIMIT ,25. My question is for pagination reasons is there an alternative to getting the number of total rows?So I have a table that has a little over 5 mill
阅读背景：
Mysql SQL_CALC_FOUND_ROWS和分页
来源：互联网
分享到：
