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

Datatable performance

SOLVED
Highlighted
Gravel

Datatable performance

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Datatable performance

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

 

 

View solution in original post

4 REPLIES 4

Re: Datatable performance

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

 

 

View solution in original post

Re: Datatable performance

@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

Re: Datatable performance

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

Re: Datatable performance

Hi @jmehta.

 

If one of the previous responses answered your question, please mark the appropriate one as the Accepted Solution for the benefit of others on the community.

 

Regards.

 

--Sharon