Performance Question...

[chrisjames]

Hi JayF & Co.,

Great, so this is what we would like to do in Excel now that we know it will work with the desktop API...

Right now we are pulling in quotes using DDE form eSignal which work fine for flat quotes, etc... but at the SAME time we would like to pull in about 20 or so quotes using VB inside Excel and the ActiveX and also place them onto the spreadsheet at the same time so we can fire events on that data...

With dde you are very limited WITH events and such.

So, at the same time we are using the DDE with Excel and pulling quotes into Excel using the API and VB we also want to be saving raw data to Access Database Tables (or SQL Server) using the API as the pull code...

so there should not be problem to do all three of these at once should there... i know its a little computer intensive but the computer will be dedicated to this one app alone

please advise...

Chris James

[JayF]

With 20 or so quotes, you should be fine performance wise. The DDE link gets it's data direct from the Data Manager, while the Desktop API (ActiveX) gets it's data from eSignal, so there shouldn't be any elbowing to get quotes down from those different mediums.

[wildfiction]

Is there a diagram or some documentation that shows the difference in the underlying communication architecture between the way the different parts of eSignal/DataManager/DDE Clients/Active X Clients communicate.

Thanks

[DuaneG]

I suggest going through the Active X file sharing group as there is a plethora of information regarding architectural relationships between the desktop API and eSignal. This is quite a handy resource for the development community or anyone who may be entertaining the idea of building his or her own software.