Novice Thingworx developer here. We have some existing Navigate apps developed by a 3rd party and I am trying to understand them so I can create new ones. My background and experience is in relational databases. Some of the data that is managed in these apps is managed in a data table. I can see the records in the data_table. These record counts range from a few hundred to a few thousand entries. A related app has data records that total up to tens to hundreds of thousand records. Those are stored in their own SQL Server table. The developer wrote a SQLDatabaseConnection Thing and a DataShape to manage that interface. Is there a common rule when you go one way vs another?
Solved! Go to Solution.
Hi @avillanueva
Please check this post : Where Should I Store My Thingworx Data? - PTC Community
There is no common rule for defining where to store data, but it is recommended to use an external database with a JDBC connection for better performance.
/VR
Hi @avillanueva
Please check this post : Where Should I Store My Thingworx Data? - PTC Community
There is no common rule for defining where to store data, but it is recommended to use an external database with a JDBC connection for better performance.
/VR
