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

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

How to fetch the old data quickly from DB

AP_9587236
17-Peridot

How to fetch the old data quickly from DB

SnowFlake database is connected to my thingworx. DB have almost past 5 years data. So while fetching old datas, it takes 2 minutes to show output. How to fetch the old data quickly from DB. 

1 REPLY 1

@AP_9587236 ,

 

If you run the same queries in another client, do you get faster response times?  If not, you may need to do some analysis on your queries first before you try any changes in the ThingWorx platform.

 

Nick

Top Tags