How to pagination many data?(data count example 100,000)

I want to display more than 100,000 data on a 1page 10data.
For example, when i press page 1023, Data from 10221 to 10230 should be displayed.
In this case, should I use 'search after' instead of 'scroll'?
If it is being developed by C++ and needs to use 'search after', I wonder if it is possible to find the '_pit id' and then create a formula to operate 'search after' several times to obtain the desired value.

I ask for your help.

Yes, a recommend way to paginate through data would be to use _pit with search_after

1 Like

thank you :slight_smile:
I will refer to it and solve it well.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.