Showing a winform in Excel is slow the first time

[Torben Laursen]

I have a COM shared add-in written in C# that I use in Excel.
One of the thinks that the user can do is to open some winforms.

The problem that I have is that the first time the user opens a winform it
is slow around 7 seconds and after that it takes no time.
Is there a way to speed up the process to show the winform the first time?

Thanks Torben

 

[Nicholas Paldino [.NET/C# MVP]]

Torben,

Is the showing of the form the first thing that is done when your COM
object is loaded? There are a few things that I can think of that are going
on here. The first is that the showing of the form is the first time your
COM object is referenced, and that causes the CLR to spool up, which is
going to have some overhead.

Also, if showing the form is the first operation that you are doing, is
there any initialization in the form, or in the add-in that could be
accounting for this?

Hope this helps.

 

[Torben Laursen]

Nicholas,

The forms are not shown until some time after the COM is loaded.
The COM is loaded and it adds a new menu item to Excel.
The user can then use this menu item to show some forms.
The forms has some code in the constructor but very little, like setting the
active tabpage.
The forms has some components on them mostly tabpages and radiogroups

Torben

Torben,

Is the showing of the form the first thing that is done when your COM
object is loaded? There are a few things that I can think of that are
going on here. The first is that the showing of the form is the first
time your COM object is referenced, and that causes the CLR to spool up,
which is going to have some overhead.

Also, if showing the form is the first operation that you are doing, is
there any initialization in the form, or in the add-in that could be
accounting for this?

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I have a COM shared add-in written in C# that I use in Excel.
One of the thinks that the user can do is to open some winforms.

The problem that I have is that the first time the user opens a winform
it is slow around 7 seconds and after that it takes no time.
Is there a way to speed up the process to show the winform the first
time?

Thanks Torben

 

[lynn.j.gasch at geemail]

Here are some articles that might help:

http://msdn.microsoft.com/msdnmag/issues/06/02/CLRInsideOut/default.aspx
http://msdn.microsoft.com/msdnmag/issues/06/05/CLRInsideOut/

--ljg