3 ms·
I would really like to see an implementation of MySQL's SQL_CALC_FOUND_ROWS. It's super handy for pagination.
by cvburgess 12y ago
I would really like to see an implementation of MySQL's SQL_CALC_FOUND_ROWS. It's super handy for pagination.
- masklinn 12y agoAccording to http://www.percona.com/blog/2007/08/28/to-sql_calc_found_rows-or-not-to-sql_calc_found_rows/ http://www.percona.com/blog/2007/08/28/to-sql_calc_found_row... (which is a very old thread and may be completely outdated), it's also often much slower than just doing two queries.
- cvburgess 12y agoGood to know! Although, like you said, that thread dates back to MySQL 5.0 - I wouldn't hedge my bets on it today... Is there a "best practices" way to handle pagination of complex queries without running the query twice?