4 ms·
Hummm, not sure I follow but most likely no. What parent mean is that there may be holes in the sequence of primary keys. What you do with pagination is that y
by siscia 7y ago
Hummm, not sure I follow but most likely no.
What parent mean is that there may be holes in the sequence of primary keys.
What you do with pagination is that you first sort the sequence, then thrown away the first N results, and finally select only the next M results.
It will work just fine.
- abhishekjha 7y agoI have linked the article for the above process.
- felixyz 7y agoThat is one way, not necessarily the most efficient. And having gaps in the id sequence can complicate pagination. Recommended reading: https://www.citusdata.com/blog/2016/03/30/five-ways-to-paginate/ https://www.citusdata.com/blog/2016/03/30/five-ways-to-pagin...
- quietbritishjim 7y ago> What parent mean is that there may be holes in the sequence of primary keys. Are you sure that's what they mean? It's not what they said. "Monotonic" means "strictly increasing" (or decreasing) e.g. 1, 2, 5, 7 is monotonic even though it has gaps. "Contiguous" means "without gaps".