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?
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.
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.