技術文章 - 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"
This is a PDF version of Article 261063 and may be out of date. For the latest version https://www.ptc.com/tw/support/article/CS261063