Skip to main content
J
jmehta1-Visitor
1-Visitor
August 30, 2019
Solved

Datatable performance

  • August 30, 2019
  • 1 reply
  • 1799 views

We have about 60 K records in total 30 Datatables, with highest records 30 K in one. Currently 1 HTTP request / second is handled in which CRUD operations performed in 6 - 10 Datatables.

 

We feel that this can cause performance issue. How do we solve this?

Best answer by slangley

Hi @jmehta.

 

ThingWorx Datatables were not designed for dynamic data.  If the data is time series data or property values, a stream/value stream might be more appropriate.

 

Can you provide more detail regarding your configuration and what type of data is being stored in the datatables?  What is the expected growth rate of these datatables?

 

If you can provide more information, we will try to make some suggestions to avoid performance issues.

 

Regards.

 

--Sharon

 

 

1 reply

S
slangleyCommunity ManagerAnswer
Support
September 5, 2019

Hi @jmehta.

 

ThingWorx Datatables were not designed for dynamic data.  If the data is time series data or property values, a stream/value stream might be more appropriate.

 

Can you provide more detail regarding your configuration and what type of data is being stored in the datatables?  What is the expected growth rate of these datatables?

 

If you can provide more information, we will try to make some suggestions to avoid performance issues.

 

Regards.

 

--Sharon

 

 

    J
    jmehta1-VisitorAuthor
    1-Visitor
    September 10, 2019

    @slangley 

     

    Thank you for reply!

     

    Data stored in DataTable is not time series or observational data, it is Transnational. Some of which updated frequently and some on them rarely. Because of transnational nature of data we have used DataTables.

     

    Considering configuration as server configuration, our instance is hosted with PTC so enough resource is available and if you have some suggestion we will ask PTC to do the same.

    Growth of data is not more than 500 rows per day in total but no. of requests are more.

     

    Regards,

    Vivek

    S
    slangleyCommunity Manager
    Support
    September 11, 2019

    Hi @jmehta.

     

    There are many unknowns here that require a more in-depth analysis of your needs--both current and long-term.  Therefore, it is recommended that you engage with Sales to arrange for a Services engagement.

     

    Regards.

     

    --Sharon

    Terms & ConditionsAccessibility statement