Want to know what is the size limit for DataTable entries when using MS SQL as persistence provide? One of the help documents says, that the size limit should not be greater than 1,00,000 for Postgress. So which is better to be used at industrial level.
Hello @MM_9023322 ,
Pls check this article explaining all the info related to your query:
kindly revert back if you have anything further.
A data table can have more than 100,00 rows, there is no limitation, but if a data table has more than 100,000 rows there will be performance issues and it is recommended to use an external database in such case.
You can find more information in this guide.