Skip to main content
J
JK_1074468213-Aquamarine
13-Aquamarine
March 6, 2025
Question

GetPropertyValuesAsMultiRowTable sometimes running very slow on thing

  • March 6, 2025
  • 2 replies
  • 824 views

Hi all,

 

I am experiencing a strange hang up on this service GetPropertyValuesAsMultiRowTable on one of my team's Things. 

Most of the time the service runs okay and outputs immediately very quickly. Sometimes however the service will take much longer (~25 seconds). I was able to narrow down the slow runtime to this specific service, but it is a built-in service so I am unable to look further into what would cause this service to randomly be slower only sometimes.

If anyone has any information on the inner workings of the service, or what would cause this service to run slow only sometimes on the same thing, please let me know. 

2 replies

J
JK_1074468213-AquamarineAuthor
13-Aquamarine
March 6, 2025

Version 9.3.19

S
slangleyCommunity Manager
Community Manager
March 13, 2025

Hi @JK_10744682 

 

Please let me know if you would like me to open a case on your behalf.

 

Regards.

 

--Sharon

G
geva15-Moonstone
15-Moonstone
March 12, 2025

Hello - you should open a technical support case about this specific issue and a Tech Support Engineer can help you figure out what is going on.

As a general rule, be watchful of the parameters being passed to the API.  If you are not calling out the properties that you need, then the entire property value cache will need to be queried and returned and this can be problematic if you have either large properties or many properties.  Example 400 properties with 5 InfoTables each with 600 rows... can be a lot of data.

Regardless of having visibility to ThingWorx code, you can use Garbage Collection log analysis as a means of seeing and quantifying a memory spike like the above which could be causing such execution latency.

Terms & ConditionsCookie settingsAccessibility statement