I thought best practice was some form of key based pagination. If you must keep things in numbered pages and want to allow skipping to page x of y, then you ar

I thought best practice was some form of key based pagination. If you must keep things in numbered pages and want to allow skipping to page x of y, then you are backed into a realized view that includes the page numbers in the data, at some level. You either build that on the fly every time you do a query, or you prebuild it. (Note, I'm not positive my thought here is accurate.)