That's an old chap : http://fabrikar.com/forums/index.php?threads/is-there-any-way-to-disable-sql_calc_found_rows.33874/
But 8 years after, fabrik still uses it.
Meanwhile, it has become deprecated : https://dev.mysql.com/worklog/task/?id=12615
Does this latter link give any hint on how to get rid of SQL_CALC_FOUND_ROWS?
what we have in fabrik 3.9 in list.php:
But 8 years after, fabrik still uses it.
Meanwhile, it has become deprecated : https://dev.mysql.com/worklog/task/?id=12615
Does this latter link give any hint on how to get rid of SQL_CALC_FOUND_ROWS?
what we have in fabrik 3.9 in list.php:
Code:
/**
* Testing potential fix for FOUND_ROWS performance issue on large tables. If merging,
* we never do a SELECT FOUND_ROWS(), so no need to use SQL_CALC_FOUND_ROWS.
*/
$calcFoundRows = $this->mergeJoinedData() ? '' : 'SQL_CALC_FOUND_ROWS';