Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)

by

It depends. See the MySQL Performance Blog post on this subject: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?

Just a quick summary: Peter says that it depends on your indexes and other factors. Many of the comments to the post seem to say that SQL_CALC_FOUND_ROWS is almost always slower – sometimes up to 10x slower – than running two queries.

More Related Contents:

  1. MYSQL OR vs IN performance
  2. How do I add indexes to MySQL tables?
  3. Storing JSON in database vs. having a new column for each key
  4. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  5. a count for each join – optimisation
  6. Measuring actual MySQL query time
  7. Speeding up row counting in MySQL
  8. MySql views performance [closed]
  9. “SELECT COUNT(*)” is slow, even with where clause
  10. Optimization of MySQL search using “like” and wildcards
  11. Using index, using temporary, using filesort – how to fix this?
  12. Should I normalize my DB or not?
  13. How to speed up sql queries ? Indexes?
  14. what will be the sql query code of this “Healthcare” database?
  15. Find nearest latitude/longitude with an SQL query
  16. Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
  17. How to display UTF-8 characters in phpMyAdmin?
  18. convert_tz returns null
  19. Convert MySQL to SQlite [closed]
  20. MySQL autoincrement column jumps by 10- why?
  21. Best data type for storing currency values in a MySQL database
  22. ERROR 1067 (42000): Invalid default value for ‘created_at’
  23. MySQL Workbench: How to keep the connection alive
  24. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  25. MySQL: ALTER IGNORE TABLE gives “Integrity constraint violation”
  26. How does MySQL’s ORDER BY RAND() work?
  27. What is the difference between SQL and MySQL? [closed]
  28. how to use a like with a join in sql?
  29. Escaping the colon character ‘:’ in JPA queries
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment