URGENT!!! RTD updates maximum frequency

[marsou]

Hello group,

I really need help here - and the faster the better because we got
stuck!!!

RTD FAQ on MS site
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xlrtdfaq.asp
) claims that maximum frequency for updating one topic is 200 updates
per second.
In our attempts to calculate the frequency with which Excel is able to
refresh data we couldn't get more than 63-65 updates per second.
Did anyone try it and got 200 updates per second? If yes what is the
structure of your RTD server.

TIA,
marsou

 

[John.Greenan]

I don't think that 200 updates per second is actually going to happen with
anything other than a random number generator. One of the RTDs that I've
worked with have been for trade execution average prices, so they are hooked
up to a TIB (www.tibco.com) backbone to update average prices for orders.
This will tick over with many three events per subject per second at most, so
it's really not hitting the limit.

What is going on in your RTD server? What are you calculating? What's the
client side hardware? Where does the data come from? These are some of the
questions that you need to look at to see what the problem is.

 

[marsou]

Thank you for your reply John,

We are now just trying to measure what we have and can we really use
RTD for our purposes. For now our RTD server does nothing except
sending out iterated numbers ( it can be called random numbers, because
there is no actual logic there).
The logic is - we send update request and after getting refresh from
excel, we send another update request (we tried different approaches:
like timers, waker windows, threads etc). However we couldn't reach for
something better than 63-65 refreshes per second for one topic. It
doesn't agree with MS claims about 200 so I was asking if anyone have
actually seen it.

marsou

 

[John.Greenan]

Hi,

have you tried using the code at
http://support.microsoft.com/kb/285339/

and modifying TIMER_INTERVAL to a smaller number?

I don't understand this:

The logic is - we send update request and after getting refresh from
excel, we send another update request (we tried different approaches:
like timers, waker windows, threads etc).

How are you running this? Can you explain in more detail? If you are
trying to get a feedback loop from excel back to the RTD you are not going to
get good performance. The only way to get this to fly is to have the RTD
generate the updates outside of the realm of the Excel GUI.