Mysql how does limit work

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Quality code is the easiest to delete. Upcoming Events.

Featured on Meta. Now live: A fully responsive profile. Candidate changes in Moderator Election — review your ballot. Outer Join Optimization. Outer Join Simplification. Multi-Range Read Optimization. Constant-Folding Optimization. Function Call Optimization. Window Function Optimization.

Row Constructor Expression Optimization. Avoiding Full Table Scans. Optimizing Subqueries with Materialization. Derived Condition Pushdown Optimization. Optimizing Performance Schema Queries. Optimizing Data Change Statements. Optimizing Database Privileges. Other Optimization Tips. Primary Key Optimization.

Foreign Key Optimization. Multiple-Column Indexes. Learn more. Asked 7 years, 6 months ago. Active 7 years, 6 months ago. Viewed 5k times. I'm seeing this SQL still running after 30 mins or more, and appearing not to do anything. What I want to clarify specifically is this: Does MySql attempt to fetch the entire table from a DB before then just returning the first 10 rows OR Does MySql fetch rows as it receives them and stop after it counts that it's recieved 10 rows Cheers Shawty.

Improve this question. Or some complex derived table? Would this solve your problem? Show 4 more comments. Active Oldest Votes. Improve this answer. Alexandros Alexandros 3 3 gold badges 11 11 silver badges 23 23 bronze badges. Thank you. Hi there! I'd suggest to make sure that your database does not define a directory.

If a directory is defined - make sure to change it in your database. You'd also need to make sure that your database credentials are well and the php file can connect to it.

You must be logged in to post a comment. Copy link. All Limited Offers Use Coupon. The author Richard Boyett. More from Richard Boyett. Related tutorials. By Jordana Alexandrea. By Edgaras G. By Domantas G. Leave a comment. Olga December 08 Log In to Reply.