Sizing Limits of Data Tables using MS SQL

[MM_9023322]

Hi all,

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. 

Thank you,

Divya Mirajkar

[bchaudhary]

Hello @MM_9023322 ,

Pls check this article explaining all the info related to your query:

https://www.ptc.com/en/support/article/cs316989

kindly revert back if you have anything further.

Regards

Bhawna

[SachinSharma]

@MM_9023322 

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.

Regards,

Sachin Sharma