SQL_CALC_FOUND_ROWS

tali

Member
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:
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';
 
We are in need of some funding.
More details.

Thank you.

Members online

No members online now.
Back
Top