June 19, 2013

Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?

Keep in mind that this test is a bit outdated (2007.) and … a client’s real-life (big) news publishing site with MySql 5.1 and InnoDB engine and real life queries (that… results… which makes sense sort of, since SQL_CALC_FOUND_ROWS was added to optimize queries in the first place… my guess is that the…