To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?

(Alexey Kovyrin) When we optimize clients’ SQL queries I pretty often see a queries with SQL_CALC_FOUND_ROWS option used. Many people think, that it is faster to use this option than run two separate queries: one – to get a result set, another – to count total number of rows. In this post I’ll try t

Read More - Register for Free Membership