MySQL Forums
Forum List  »  Newbie

Re: MySQL pagination
Posted by: Eran Yasso
Date: September 02, 2017 11:14AM

Hello Peter,

I don't understand why it returns 1001 and not 501. the offset set to 500 and productid is set to above 500. For both case, as I understand should return from 501 to 1000.

Another question is, as I read using offset in large tables (above 200k) is bad for optimization, because MySQL reads all the data until offset. By using productid larger than instead of offset, would it solve the optimization?

Options: ReplyQuote


Subject
Written By
Posted
September 01, 2017 12:29AM
September 01, 2017 09:57AM
Re: MySQL pagination
September 02, 2017 11:14AM
September 02, 2017 12:16PM


Sorry, only registered users may post in this forum.

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.