Feb 10, 2022 06:21 AM
Hi, I have this table in Airtable which has for about 10k data. I try to display it with datatable and it takes quite a long time to fully load the table. Is there a way to lazy load the airtable and display it on datatable?
Feb 10, 2022 08:50 AM
What do you mean by Datatable? Are you talking about the grid view?
Or do you mean https://datatables.net/?
Feb 10, 2022 09:37 AM
Welcome to the Airtable community!
Are you accessing Airtable via the REST API? If so, you are limited by the capabilities of the API. You can get a maximum of 100 records per request, with a maximum of 5 requests per second. You cannot get the data from the Airtable API any faster.
You could use methods that involve caching the data somewhere else, such as using sequin.
Feb 10, 2022 02:45 PM
Hi, Arthur, I’m using the nocode api to get the data from airtable, then displaying it with datatables
Feb 10, 2022 03:27 PM
Hi, thank you for your reply.
Yeah I’m using the REST API through Nocode API. I can get all the data, but it takes to long to load all the records at once. In datatable we can use server side processing which I can load 10 out of 10000 data at first. But there are some return parameter that I should get like recordsTotal, recordsFiltered (Server-side processing) which I can’t get from the current REST API.
With Sequin, can I do this? Or do you have other suggestions?
Feb 10, 2022 04:49 PM
Sorry, I haven’t worked with sequin enough to know if it can provide the server side processing you want.