How slow is FOUND_ROWS function in MySQL
From many reasons I was always using SQL_CALC_FOUND_ROWS to get total number of records, when I was running limited query. Never especially thought about it, until i had some super performance issues with one of my projects. Obviously after quick profiling and googling i found people complaining about FOUND_ROWS() low performance . I was not aware how big impact it was until I tested.