RTD Performance

Add-in Express™ Support Service
That's what is more important than anything else

RTD Performance
 
Ranjitha Nagendra




Posts: 40
 Joined: 2015-10-26
Hello team,

I have a spreadsheet wherein I have thousands of RTD functions for which interval has been set to 500. when the sheet is open, data gets constantly updated, but CPU usage goes upto 40%. How to optimize this?

Regards,
Ranjitha
Ranjitha
Posted 21 Nov, 2016 05:36:50 Top
Andrei Smolin


Add-in Express team


Posts: 18821
 Joined: 2006-05-11
Hello Ranjitha,

First off, Microsoft sets the default value for dealing with RTD requests to 2 seconds. Second, there are two ways to deal with performance: 1) diminish the number of RTD calls; 2) switch to using a COM add-in which puts the new values directly to the cells.


Andrei Smolin
Add-in Express Team Leader
Posted 21 Nov, 2016 06:13:16 Top
Ranjitha Nagendra




Posts: 40
 Joined: 2015-10-26
Hi Andrei

1) I changed interval value to 2000 - still did not help
2) I am using a COM addin only, where in I have one ADXAddinModule, ADXRTDServerModule, ADXXLLModule(which contains wrapper functions for my RTDs)

Regards,
Ranjitha
Ranjitha
Posted 21 Nov, 2016 06:30:31 Top
Andrei Smolin


Add-in Express team


Posts: 18821
 Joined: 2006-05-11
Hello Ranjitha,

I was talking about using a COM add-in instead of an RTD server. I suppose you won't be able to speed up the code in any significant degree within the RTD technology.


Andrei Smolin
Add-in Express Team Leader
Posted 22 Nov, 2016 04:31:05 Top
Ranjitha Nagendra




Posts: 40
 Joined: 2015-10-26
You mean using COM-Addin to manually write the values using range.Value2? I get the values constantly from a server through websocket. Manually writing values in cell is even more CPU consuming.
Ranjitha
Posted 22 Nov, 2016 04:35:37 Top
Andrei Smolin


Add-in Express team


Posts: 18821
 Joined: 2006-05-11
Then I don't see any way to solve the issue.


Andrei Smolin
Add-in Express Team Leader
Posted 23 Nov, 2016 05:49:29 Top