qq_28086271的博客

分页查询sql性能问题分页:SELECT COUNT(*) from T1 WHERE …; 查出总数SELECT * FROM T1 WHERE … limit m,n; 查询分页优化:SELECT SQL_CALC_FOUND_ROWS * FROM T1 WHERE … limit m,n;SELECT FOUND_ROWS();SELECT FOUND_ROWS();查询不耗sql性能，获取上一次查询结果的总条数(不受limit限制)。...