GetPropertyValuesAsMultiRowTable sometimes running very slow on thing

[JK_10744682]

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. 

[JK_10744682]

Version 9.3.19

[geva]

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.