How to fetch the old data quickly from DB
‎Jul 04, 2022
11:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Jul 04, 2022
11:38 AM
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.
Labels:
- Labels:
-
Troubleshooting
1 REPLY 1
‎Jul 05, 2022
09:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Jul 05, 2022
09:28 AM
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