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 Carys,
There isn't really a hard limit.
However, if the table contains a large number of rows (e.g. more than 2000) it could cause problems for the client systems to load and present all data.
In such cases, it's better to add the partial option to your table, so only the first x number of rows (1000 by default) are loaded in the UI.
Floris Cockaerts [SLC] [DevOps Enabler] Posted new comment 17th August 2023
Just to put some numbers out there, although there are plenty of performance and memory complications when going to 100K rows and above, there is currently a limit at 2^32-1 where the software will not be able to correctly store and retrieve data in its data structures, even when running the 64-bit version of SLProtocol.