MySQL counts the total number of rows

Question

I have a complex MySQL query, which takes a lot of time, choosing from the table more than 150 thousand rows and several JOINS and subqueries. I limit the number of results, but I need to know the total number of rows.

Is there a way to not repeat the request with COUNT(*)as a field to receive them? (repeating the request almost doubles the time it takes to complete the script)

Answer 1

Actually, it might be faster to complete two queries (so you can just do the testing quickly):

• http://www.mysqlperformanceblog.com/2007/08/28/to-sql_calc_found_rows-or-not-to-sql_calc_found_rows/

, COUNT (*) ( " " "", EXPLAIN)

COUNT (*), ( ).

Answer 2

MySQL SQL_CALC_FOUND_ROWS, SELECT . , SELECT FOUND_ROWS() AS rows, , .