v8 How to use built in pagination and fetch more data

[rlawrence89]

Scenario-
I am using graphql to fetch 25 records at a time from a database. I pass this data into tanstack table v8. I can get this working with manual pagination where when the page index increases it runs a fetch query to pull the next 25 records.

My question, Is it possible to pull 1000 records at a time and once i navigate to the page with the 1000th record fetch more data, using the table pagination apis?