Skip to main content
17-Peridot
July 4, 2022
Question

How to fetch the old data quickly from DB

  • July 4, 2022
  • 1 reply
  • 707 views

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

17-Peridot
July 5, 2022

@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