Article - CS261063

Performance of QueryDataTableEntries Service on ThingWorx is Poor

Modified: 29-Apr-2021   


Applies To

  • ThingWorx Platform 7.4 to 8.5
  • PostgreSQL

Description

  • When querying a Data Table in ThingWorx, it takes multiple seconds to return a result;
  • Using the QueryDataTableEntries service is slow
  • Poor performance when querying Data Tables on PostgreSQL
  • Frequently transaction full issue in the PostgreSQL database
  • The QueryDataTableEntries service times-out with "504 Gateway Error"
This is a PDF version of Article CS261063 and may be out of date. For the latest version click https://www.ptc.com/en/support/article/CS261063