Currently I'm doing two queries in my pages, in an extra, the list of data according to the page:
SELECT * FROM tabla LIMIT 20,10
In another I apply the
COUNT to obtain how many records in total that query has:
SELECT COUNT(*) FROM tabla
Is there a way to not make two queries and get the number of total records in the same table of
LIMIT no matter what happens again?
Or some method to optimize that query? I work with