Solved: storing service output in Datatable in Thingworx

SM_10230689 · ‎Sep 12, 2022

How can we store a service output in DataTable insted of InfoTble in Thingworx.

danmorin · ‎Sep 12, 2022

I would say it would depend on your use case. Kindly refer to the best practice below

https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Composer/DataStorage/DataTables/DataTableBestPractices.html

In short, if your data is on a row-by-row basis update or change, and easy to look up I would recommend a data table, But if your data relatively doesn't have many rows, doesn't need to look up on specific row and logically easier to relate it with the specific thing then I would recommend an infotable

From my experience don't use infotable if it contains more than 500 rows, and use databaseThing to connect to database if your rows size is more than 50000. Otherwise it will cause a performance issues on ThingWorx.

Thanks

View solution in original post

danmorin · ‎Sep 12, 2022

Hi @SM_10230689

I would say it would depend on your use case. Kindly refer to the best practice below

https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Composer/DataStorage/DataTables/DataTableBestPractices.html

In short, if your data is on a row-by-row basis update or change, and easy to look up I would recommend a data table, But if your data relatively doesn't have many rows, doesn't need to look up on specific row and logically easier to relate it with the specific thing then I would recommend an infotable

From my experience don't use infotable if it contains more than 500 rows, and use databaseThing to connect to database if your rows size is more than 50000. Otherwise it will cause a performance issues on ThingWorx.

Thanks