Article - CS363996
Performance of QueryDataTableEntries Service is Poor on ThingWorx with SQL Server database
Modified: 01-Mar-2022
Applies To
- ThingWorx Platform 7.4 F000 to 9.5 F000
Description
- When querying a DataTable in ThingWorx it takes multiple seconds to return a result
- Using the QueryDataTableEntries service is slow
- Poor performance when querying DataTables on Microsoft SQL Server
- The QueryDataTableEntries service times out with "504 Gateway Error"
This is a printer-friendly version of Article 363996 and may be out of date. For the latest version click CS363996