VB versus VB.NET timings!!

[Nak]

I ANAL, but you should be fine; you're trying to figure out what's

wrong with your code. It's to prevent articles like "C# vs. Java",
etc.

LOL, please inform me what you mean by "ANAL" as I think I have the wrong
idea :-\

Nick.

 

[Vadim Rapp]

Hello Siv:
You wrote in conference microsoft.public.dotnet.languages.vb on Mon, 13 Sep
2004 01:04:50 +0100:

S> Details as follows:
....

it's very hard to judge, having the code you provided. The code does too
many various things. If you want to narrow down the performance difference,
you have to split your code by many parts, each repetitively performing some
atomic function, then measure each one.

That's why Microsoft is trying to limit publishing the benchmarks. Actually,
you should ask your question not in the newsgroup, but rather send it to
Microsfot media contacts. Most likely, they would try to evaluate what
audience would read your results, and if large, they would probably assign
someone who would eventually help you either to improve the performance, or
at least to get more accurate and representing results.


Vadim

 

[Siv]

Vadim,

Thanks for your comments. Sorry I didn't respond quickly have been "up to
my eyeballs in it!" and haven't looked in on this thread for a while.

You mention "Microsoft Media Contacts" what or who is that?? and how do I
contact them?

Siv

 

[Vadim Rapp]

Hello Siv:
You wrote in conference microsoft.public.dotnet.languages.vb on Fri, 17 Sep
2004 11:14:22 +0100:

S> You mention "Microsoft Media Contacts" what or who is that?? and how do
S> I contact them?

I have no such experience, but if you click "for journalists" at
www.microsoft.com, then PR contacts, then you'll find "rapid response team".

Vadim

 

[Siv]

Cheers Vladim,
I'll try that.
Siv

 

[Guest]

CreateObject creates an instance of Excel. The easiest workaround is
available even in VB6 which i think you did not try in VB6 itself. If you
are using ADODB, Create two different connections. One with your SQL server
and the other with the excel file. You can use the Jet OLEDB provider to
conect to EXCEL files. The only change will be that the SQL string will be
like

"select * from [Sheet1]"

of course with square brackets for sheet name which is considered as table.
In this way your whole excel data is in your recordset. Doing your
processing between recordsets which has Cachesize property set with an
optimised value something like 200 can make extraordinary performance
difference.

Now in Dot NET you can still open Excel files as Dataset or Datareader as
required. You have to find methods or providers and how to do this yourself.
The moral of the story is not to use CreateObject or GetObject. To get the
connection string of how to connect to excel files or text files using ADODB
or DotNET in multiple languages, check www.able-consulting.com and find
connection strings page.

I have done this with Excel files with 125 columns and over 80,000 rows with
multiple sheets and processed against AS400 tables [PF] using VB6's ADODB
connections. [ADODB connections are independent in same project for both
Excel and AS400]

Good luck
Raja Venkatesh
(e-mail address removed)