cakephp paginate using mysql SQL_CALC_FOUND_ROWS
- by michael
I'm trying to make Cakephp paginate take advantage of the SQL_CALC_FOUND_ROWS feature in mysql to return a count of total rows while using LIMIT. Hopefully, this can eliminate the double query of paginateCount(), then paginate().
http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_found-rows
I've put this in my…