MySQL Forums
Forum List  »  Quality Assurance

SELECT ... LIMIT x,y becomes slow with larger x
Posted by: Per Lindberg
Date: September 22, 2011 02:47AM

I just discovered that selecting a bunch of records with

SELECT * FROM table LIMIT start,count

gets slower with increasing values for 'start'.

I had thought that this would be a great statement to process a huge InnoDB table (millions of records) in batches (instead of all at once), but alas...

Is this a bug or a feature in MySQL?

Options: ReplyQuote

Written By
SELECT ... LIMIT x,y becomes slow with larger x
September 22, 2011 02:47AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.