SQL_CALC_FOUND_ROWS performance code example

Example: sql_calc_found_rows

Copied SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name WHERE id > 100 LIMIT 10;
SELECT FOUND_ROWS();