DEV Community

Discussion on: Performant Pagination Technique for SQL databases

Collapse
 
labeebahmad203 profile image
Labeeb Ahmad

Hi Andrei, first off, thanks for reading the article. If you are concerned that DBMS might order by ID in a different way than what you expect.

In that case you can always go for custom collation. dev.mysql.com/doc/refman/5.6/en/ad....

A collation basically is set of rules used by DBMS to compare & sort strings. It is much like a comparator function you are used to in JS.

This way you can make your comparisons predictable & inline with your business needs.

Collapse
 
anduser96 profile image
Andrei Gatej

Thank you very much!