InvokeMember in Excel Add-in : 40% cpu load problem

[mxbrunet]

Hello everyone,

I'm currently building an Excel add-in using VB.Net and am experiencing
some weird effects on one of my test machines. I am running a series of
demanding calculations on a sheet, and on the affected machine, when
profiled, it shows that System.RuntimeType::InvokeMember uses up close
to 40% of the CPU. The machine is running Office 2003 Pro in french, on
Windows XP (also french) - it's a Pentium M 2.0GHz. However, on my
machine, using an english combination of the same software, the load
does not even come close to 40%.

Would anyone have any thoughts, or leads regarding this issue. I'm
drawing a blank.

Thanks a lot for all your help.

..max

This is one a the sequences that I got from the profiler:

System.Globalization.NumberFormatInfo::get_CurrentInfo
System.RuntimeType::ForwardCallToInvokeMember
System.OleAutBinder::ChangeType
System.Reflection.ParameterInfo::get_ParameterType
System.Reflection.RuntimeMethodInfo::get_ReturnType
System.Reflection.RuntimeMethodInfo::GetParametersNoCopy
System.Runtime.Remoting.Messaging.Message::GetMethodBase
System.Runtime.Remoting.Messaging.Message::InitFields
System.Runtime.Remoting.Proxies.RealProxy:ropagateOutParameters
System.RuntimeType::InvokeMember
System.RuntimeType::IsByRefImpl
System.String::Concat:1
System.String::Equals:1

 

[XL-Dennis]

Max,

If the *only* difference is the language in use between the two computers
then it must be related to some 'behind the scene' technical aspect. Do You
also experience that it take longer time to execute on the computer

I hope that someone from MSFT technical staff member can make a comment
about it.

I use English and Swedish version of Windows XP / Excel and so far have not
noticed the difference You point out. But I've so far not have had any reason
to make intensive calculations on sheets.

---------------
With kind regards,
Dennis
Weekly Blog .NET & Excel: http://xldennis.wordpress.com/
My English site: http://www.excelkb.com/default.aspx
My Swedish site: http://www.xldennis.com/