Excel Update - Excel thread is busy every 10 seconds

[GaryRussell]

Can you try version 1.1.0.52 and let me know if it still shows the message. If it does show the message then there will be a figure in brackets after the message, can you let me know what this is.

Download using the link below.

http://www.gruss-software.co.uk/Betting ... t_Beta.msi

[greenfingers]

First - thanks a lot for the update, that's brilliant service!

The error has reduced, here is a copy of the log for the end of the day:
17:37:45 Excel update Excel thread is busy (47 ms)
17:40:15 Excel update Excel thread is busy (31 ms)
17:41:41 Excel update Excel thread is busy (16 ms)
17:44:21 Excel update Excel thread is busy (16 ms)
17:44:32 Excel update Excel thread is busy (94 ms)
17:44:44 Excel update Excel thread is busy (31 ms)
17:44:55 Excel update Excel thread is busy (31 ms)
17:45:07 Excel update Excel thread is busy (31 ms)
17:45:19 Excel update Excel thread is busy (31 ms)
17:45:34 Excel update Excel thread is busy (47 ms)
17:45:45 Excel update Excel thread is busy (47 ms)
17:45:58 Excel update Excel thread is busy (47 ms)
17:46:09 Excel update Excel thread is busy (47 ms)
17:46:20 Excel update Excel thread is busy (31 ms)
17:46:30 Excel update Excel thread is busy (2438 ms)
17:46:40 Excel update Excel thread is busy (16 ms)
17:47:53 Excel update Excel thread is busy (16 ms)
17:48:52 Excel update Excel thread is busy (16 ms)
17:51:53 Excel update Excel thread is busy (31 ms)
17:53:05 Excel update Excel thread is busy (109 ms)
17:54:04 Excel update Excel thread is busy (16 ms)
17:56:23 Excel update Excel thread is busy (47 ms)
17:57:05 Excel update Excel thread is busy (16 ms)
17:57:19 Excel update Excel thread is busy (31 ms)
17:58:04 Excel update Excel thread is busy (47 ms)
17:58:19 Excel update Excel thread is busy (47 ms)
17:58:30 Excel update Excel thread is busy (78 ms)
17:58:41 Excel update Excel thread is busy (141 ms)
17:58:58 Excel update Excel thread is busy (78 ms)
17:59:11 Excel update Excel thread is busy (31 ms)
17:59:25 Excel update Excel thread is busy (78 ms)
17:59:45 Excel update Excel thread is busy (78 ms)

Are these anything to worry about?

I noticed after reply to your question about CPU usage the this is signifiacntly lower if I have excel in the background - i.e. BA selected - also very low (about 10%) if I minimise the workbook within excel first.

Would I be reducing the processing of excel by doing this minimisation / risking the code not being processed for every refresh of BA? It didn't appear to be the case as I got matched on all of the automated orders - which would seem to be a good improvement from before - but as I was only running this from about 4 p.m. it's early days to say.

Thanks again.

[GaryRussell]

Nothing to worry about. It is important that the times in brackets are well under 100ms which they are on the whole. I will do some more fine tuning to see if I can get the time down further.

Excel is updated after every price refresh and the refresh is requested every 100ms when using a refresh rate of 0.1, therefore if a refresh gets a slow response then the next refresh could be small number of milliseconds away and the updates could overlap causing the busy message. This shouldn't happen the majority of the time as long as the API is performing well.

Minimising BA or Excel will not prevent the triggers being processed.

[greenfingers]

That's good to know. Thanks again