RTD performance problem

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

RTD performance problem
performance problem while connect rtd topic 
Hans Jürgen Kosiol


Guest


Hi,

while connecting a rtd topic(ConnectData method in ADXRTDServerModule),
for each topic a method IndexOfTopicStrings is called which concatenates all topic strings to one string(calling property Text of ADXRTDTopic).

The IndexOfTopicString method even iterates through all the list of topics available at the time a single topic connects, so connect of 1,400 rtd topics in one workbook results in approximately 1,000,000 calls of the Text property in ADXRTDTopic which concatenates 28 strings to one.
This is a big performance problem for us because we have excel workbooks with more than 10,000 rtd topics and so every client machine needs a lot of cpu(more than one cpu minute on 3 GHz Xeon) to connect all topics.

best regards,
Juergen Kosiol
Posted 18 Jun, 2007 07:56:58 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Hi Hans.

Thank you for the notification. I will try to optimize the code somehow in the next Add-in Express build.



P.S. We always do our best to answer your forum requests as soon as possible. However, we apply the rule "first in first out" with Premium Support Service subscribers taking priority. Please understand it may take us some time to do research on the issue. Please be assured we will let you know as soon as the best possible solution is found.






Posted 18 Jun, 2007 18:02:18 Top