How can I implement server side pagination in the datagrid?

[u.soni]

I am using external APIs to load my data and show on UI using Anvil Datagrid. While data grids provide seamless pagination on UI, I want to implement server-side paginations as I have more than a thousand records present in my database. Obviously, I cannot load all the data at once, I want a way to implement server-side pagination. I already have my external APIs ready for it, but how to implement it in Anvil using the Datagrid?

[stucork]

Here’s an approach from a related thread that might help:

What is the best practice for asynchronously loading component data?

I use a timer for non simultaneous background calls. I add a timer to the form, set the interval to 0.1 and put the server call in the tick event with _s so it doesn’t show the spinner. The timer allows to run code on the client in background, but it is going to be blocking. So I split a long call into many small ones.