MySQL Data Limit

Question

MySQL

Task: get data from MySQL with a certain limit and offset, find out the number of all elements in the table (that is, without applying limit and offset to it).
The following solution comes to mind: we get all the data without taking into account limit and offset, then, without SQL, we count them and cut them off.
You can, of course, specify limit and offset in the SQL select query, but then you will have to call a separate SQL query to count all elements.
What will be the fastest?

Answer 1

Two requests should be made: for data fetching, a request with limit and offset, for quantity - a request without limit and offset, but with the count function (no need to pull data, only count).

Answer 2

Use SQL_CALC_FOUND_ROWS when selecting with a limit, MySQL will count all records matching the parameters.

SELECT SQL_CALC_FOUND_ROWS * FROM TABLE1 WHERE .... LIMIT 40;
SELECT FOUND_ROWS()