How slow is FOUND_ROWS function in MySQL
From many different 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 wasn’t aware how big impact it was until i tested.