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

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Maximum records in datatable and stream.

dgurumukhi
6-Contributor

Maximum records in datatable and stream.

Hi Guys, 

 

Does anyone has idea, that how much records a datatable or stream can hold?

 

Thanks, 

Dushyant

1 ACCEPTED SOLUTION

Accepted Solutions

Hi,

 

There is no limitation on the maximum rows on data tables, but if a data table has more than 100 000 rows you will notice a performance issue and it is recommended to use an external database.

Please find more here: http://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/index.html#page/ThingWorx/Help/Composer/DataStorage/SizingLimitsofDatatables.html#wwID0EFIYR

 

Thanks,

Raluca

View solution in original post

2 REPLIES 2

Hi,

 

There is no limitation on the maximum rows on data tables, but if a data table has more than 100 000 rows you will notice a performance issue and it is recommended to use an external database.

Please find more here: http://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/index.html#page/ThingWorx/Help/Composer/DataStorage/SizingLimitsofDatatables.html#wwID0EFIYR

 

Thanks,

Raluca

slangley
23-Emerald II
(To:raluca_edu)

Hi @dgurumukhi.

 

If Raluca's response has answered your question, please mark it as the Accepted Solution, for the benefit of others who may have the same question.

Regards.

 

--Sharon

Top Tags