Hello, I have a table that is being populated by an API endpoint (using FillArray), is there a maximum number of rows that a table can have?
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 16th August 2023
Hi
Have a look at the Data Handling page.
There you will find some basic guidelines with very large tables:
- Performing sets (FillArray):
- Try to stay below 20 000 cells in 1 set, except if the content of a cell is a 20 MB string or something equally large, in which case you should split up more.
- Avoid setting more than 1000 rows at a time. If your table is larger than 1000 rows, use multiple sets per 1000 to improve performance.
Andries Deklerck [SLC] [DevOps Advocate] Answered question 14th August 2023