Skip to main content
D
dgurumukhi1-Visitor
1-Visitor
August 29, 2018
Solved

Maximum records in datatable and stream.

  • August 29, 2018
  • 1 reply
  • 2171 views

Hi Guys, 

 

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

 

Thanks, 

Dushyant

Best answer by raluca_edu

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

1 reply

R
raluca_edu17-PeridotAnswer
17-Peridot
August 29, 2018

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

    S
    slangleyCommunity Manager
    Support
    October 17, 2018

    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

    Terms & ConditionsAccessibility statement