Article - CS260742
How to optimize stream/data table queries in ThingWorx
Modified: 26-Nov-2024
Applies To
- ThingWorx Platform 6.6 to 9.4
Description
- QueryStreamEntriesWithData service is taking long time for execution
- QueryStreamEntriesWithData service takes too long for a stream to update / return its queried values, up to an hour
- Working with the stream (queries) takes very long time on production server
- How to optimize stream/data table queries
- How to query data tables quickly
- How to choose a stream versus a data table versus an info table
- Query would consume much tomcat resource, CPU usage is very high, even tomcat process is not responding
This is a printer-friendly version of Article 260742 and may be out of date. For the latest version click CS260742