Need to jump pages not by _creationTime
I am working on an application that is going to have an extremely long activity ledger (think hundreds of thousands maybe millions of rows eventually). I want users to be able to "browse" the ledger, sort it, and yes page it... The problem comes when there are say 50 or 100 pages + of logs.. Scrolling isn't a great experience at that size and faking pages but then having to load all those records just to "hide" them to give a "jump to page" type experience is also super wasteful to both the client (memeory) and convex servers.
What is the work around when serverside collect then slice/skip&take is a bad fit due to volume, and the pagination feature is a bad fit due to User experience or well, also volume.
What is the work around when serverside collect then slice/skip&take is a bad fit due to volume, and the pagination feature is a bad fit due to User experience or well, also volume.
