Re: Speed : The PIA impact (VB 6.0 vs VB.NET)

From: Jon Skeet [C# MVP] (skeet_at_pobox.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 14:29:02 +0100

Philippe TEIRUH <PhilippeTEIRUH@discussions.microsoft.com> wrote:
> I have made a migration from VB 6.0 to VB.NET and noticed a great speed
> change when I access (from VB) to Excel Cells (same problem to write Visio
> formulas from VB).
> The same code takes 21 seconds in VB 6.0 and 54 seconds in VB.NET (see below)
>
> 1. Is that fact well known?
> 2. How to solve the problem?
> 3. Can we hope amelioration in latter version?
>
> ---------------------------------------------------------
>
> In VB 6.0 the following code is executed in 21 seconds in VB 6.0 and 54
> seconds in VB.NET on the same PC:

Is this using Option Strict On or not? I believe interop is much slower
using Option Strict Off than On.

You will probably find that others in the VB.NET group
(microsoft.public.dotnet.languages.vb) or in the interop group
(microsoft.public.dotnet.framework.interop) can give you more
information on that. 

-- 
Jon Skeet - <skeet@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too