Retrieving only a fixed number of rows in MySQL

by

MySQL is smart in that if you specify a LIMIT 5000 in your query, and it is possible to produce that result without generating the whole result set first, then it will not build the whole result.

For instance, the following query:

SELECT * FROM table ORDER BY column LIMIT 5000

This query will need to scan the whole table unless there is an index on column, in which case it does the smart thing and uses the index to find the rows with the smallest column.

More Related Contents:

  1. MySQL offset infinite rows
  2. How does MySQL process ORDER BY and LIMIT in a query?
  3. passing LIMIT as parameters to MySQL sproc
  4. Is there a way to “limit” the result with ELOQUENT ORM of Laravel?
  5. get first occurrence of last changed value of a column [closed]
  6. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  7. multiple query same table but in different columns mysql
  8. Import data in MySQL from a CSV file using LOAD DATA INFILE
  9. How to do a batch insert in MySQL
  10. Get current AUTO_INCREMENT value for any table
  11. Creating a “Numbers Table” in MySQL
  12. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  13. Determine which MySQL configuration file is being used
  14. Rails, MySQL and Snow Leopard
  15. MySQL CONVERT_TZ()
  16. mysql trigger stored trigger is already used by statement which invoked stored trigger
  17. MySQL: #126 – Incorrect key file for table
  18. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  19. Comma separated string of selected values in MySQL
  20. MySQL InnoDB: autoincrement non-primary key
  21. How to insert a file in MySQL database?
  22. How to turn on/off MySQL strict mode in localhost (xampp)?
  23. Foreign key to one of many tables?
  24. What’s the recommended way to connect to MySQL from Go? [closed]
  25. What is wrong with my SQL here? #1089 – Incorrect prefix key
  26. How to find all the relations between all mysql tables?
  27. MySQL DROP all tables, ignoring foreign keys
  28. MySQL: Check if the user exists and drop it
  29. Get the second highest value in a MySQL table
  30. mysql double-quoted table names

Leave a Comment