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

ThingWorx Navigate is now Windchill Navigate Learn More

Translate the entire conversation x

Data_table or Relational Table? Need advice

avillanueva
23-Emerald I

Data_table or Relational Table? Need advice

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? 

ACCEPTED SOLUTION

Accepted Solutions
Velkumar
19-Tanzanite
(To:avillanueva)

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

View solution in original post

1 REPLY 1
Velkumar
19-Tanzanite
(To:avillanueva)

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

Announcements


Top Tags