… count_test WHERE b = 999 ORDER BY c LIMIT 5;”, mysql uses index to determine number of rows to examine (through… than sending two queries. I use a stored procedure that accept a dynamic sql query, an offset and a limit then use prepared statement… which accepts limit and offset do the same thing but one with SQL_CALC_FOUND_ROWS just stores number of records before…