Skip to main content
M
MM_902332215-Moonstone
15-Moonstone
February 26, 2022
Question

Sizing Limits of Data Tables using MS SQL

  • February 26, 2022
  • 2 replies
  • 992 views

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

2 replies

B
bchaudhary_4480085-Regular Member
5-Regular Member
February 28, 2022

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

S
SachinSharma16-Pearl
16-Pearl
February 28, 2022

@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

Terms & ConditionsCookie settingsAccessibility statement