기술 문서 - CS261063

Performance of QueryDataTableEntries Service on ThingWorx is Poor with SQL Server Database

수정한 날짜: 01-Mar-2022   


적용 대상

  • ThingWorx Platform 7.4 F000 to 9.2 F000
  • PostgreSQL

설명

  • 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"
이는 기술 문서 CS261063의 PDF 버전이며, 구 버전일 수 있습니다. 최신 버전 https://www.ptc.com/ko/support/article/cs261063