Building a Real Time Data server: Changing the Excel RTD Throttle Interval, part 11
This is part 11 of the tutorial that describes the techniques necessary to build an Excel RTD server. If you have just come to this page, I suggest you read all parts in order, here is Building a Real Time Data for Excel, part 1.
By default, Excel won’t call RefreshData more often than every 2 seconds (the Throttle Interval). For financial data that’s arriving fast and furiously, this is reasonable, but for GeodesiX it makes the interface seem rather slow.
To improve this, GeodesiX changes the Throttle Interval to zero, which tells Excel to call RefreshData as often as possible. This is done in Geodesix.SetRealTime.SetRealTime #34#:
This works and indeed speeds up the refresh, but you should note that it could cause other RTD applications to update too quickly.
The absolutely correct way would be to put back the throttle interval when Geodesix terminates. I couldn’t be bothered so we’ll leave it as an exercise…
Building a Real Time Data for Excel tutorial:
- Building a Real Time Data for Excel server, part 1
- Building an Excel RTD: Avoiding VSTO, part 2
- Building an Excel RTD: How RTD servers work, part 3
- Building an Excel RTD: Architecture, part 4
- Building an Excel RTD: Excel, multithreading and callbacks, part 5
- Building an Excel RTD: Providing easy-to-read function names, part 6
- Building an Excel RTD: Talking to the GoogleMaps APIs, part 7
- Building an Excel RTD: Avoiding Application Domain misery, part 8
- Building an Excel RTD: Embedding a GoogleMap page in an Excel Task Pane, part 9
- Building an Excel RTD: Creating the Setup project, part 10
- Building an Excel RTD: Changing the Excel RTD Throttle Interval, part 11
- Building an Excel RTD: Utility functions and building help, part 12