Skip to main content
dgurumukhi1-Visitor
1-Visitor
Aug 29, 2018 12:05 PM UTC
Solved

Maximum records in datatable and stream.

Hi Guys, 

 

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

 

Thanks, 

Dushyant

raluca_edu
raluca_eduAnswer
17-Peridot
Aug 29, 2018 12:56 PM UTC

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 in thread

2 replies

raluca_edu
raluca_edu17-PeridotAnswer
17-Peridot
Aug 29, 2018 12:56 PM UTC

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

Translate
    slangleyCommunity Manager
    Support
    Oct 17, 2018 6:31 PM UTC

    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

    Translate
    Terms & ConditionsAccessibility statement