Paginating many rows within time-window from huge table

NS docs state ODBC will return only 3k rows max.

But table contains millions of rows.

What is best way to paginate so as to receive a subset of only 1k rows, starting from 0 then 1001 then 2001 etc, from a massive table?

TIA

Rookie Asked on June 15, 2023 in Best Practices.
Add Comment
1 Answer(s)

You’re going to need to give us some more details.

Advanced Answered on June 15, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   SuiteMigration   Become a Sponsor