I'm trying to optimize the performance of some queries in my application.
In one query with multiple joins and a fulltext search I use SQL_CALC_FOUND_ROWS
in a first query for pagination.
Unfortunately the performance of the query is very slow, Without the SQL_CALC_FOUND_ROWS
the query is about 100 times faster.
I there a possibility to get a better performance in this case?
I tried a single count-query without the SQL_CALC_FOUND_ROWS
, but this query is an additional second slower than the SQL_CALC_FOUND_ROWS
-query.