cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

Sizing Limits of Data Tables using MS SQL

MM_9023322
14-Alexandrite

Sizing Limits of Data Tables using MS SQL

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 2

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

@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

Top Tags