VB与VB.NET时序!! [英] VB versus VB.NET timings!!

问题描述

作为对我编写的一个小实用程序的评估的一部分，该实用程序将大量Excel电子表格中保存的一些

数据转换为SQL Server，我决定将实用程序转换为VB .NET，并在IDE中运行这两个版本，并作为独立编译的exe运行
，看看它们的时间差异是什么完整

是。


该实用程序必须读取包含块的3842页单页Excel表格

数据12行深然后将55个列转移到具有相同列数的

SQL Server表中。


我认为VB .NET可能会更慢，但是我对此感到惊讶。


我想将这些调查结果发布给这个社区征求意见，但是我想念一下EULA中的内容。 NET说你不能发布

基准。现在，我不和任何人吵架，我不会想要和MS一起遇到麻烦（特别是因为我的生活在

回归微软的产品。我想要发布的只是一个

表，显示我的程序每次运行的开始和结束时间以及计算VB6和VB .NET的经过时间的
。


如果来自MS的任何人正在寻找我会很高兴知道你是否会对我发布我的调查结果不满意吗？


Siv

解决方案

*" Siv" < [e-mail]> scripsit：

我想将这些发现发布给这个社区征求意见，但我记得EULA for .NET中的一些内容，说你不能发布
基准测试。

重新阅读EULA。我记得

测试版禁止使用基准测试，但发布版本可能不是这样。


-

MS Herfried K. Wagner

MVP< URL：http：//dotnet.mvps.org/>

VB< URL：http：// dotnet.mvps.org/dotnet/faqs/>

Herfried，


我看了谷歌，发现了以下链接到.NET的EULA

框架1.1可再发行组件，它似乎包含我记得在某处弹出的行：

a ..您不得向任何第三方披露OS组件的.NET

框架组件的任何基准测试的结果，而不是

Microsoft事先获得书面批准。


我试图通过.NET IDE帮助系统寻找许可证

EULA。等等但是找不到任何东西。


我想问题是，释放我用我的

申请所做的时间是否构成了基准 ;，我不认为他们这样做，因为我确定

有人会指出我的程序应该从头开始重写

使用VB.NET而不是而不是通过转换VB6应用程序。


我发布它的原因是看看是否有人对如何改进

应用程序有任何想法在.NET下更好的速度（如你所知）从我以前的帖子中获得
我正在从VB6转换为VB.NET并期待

_learn_而不是轻视微软我希望从这个小组获得一些关于从

..NET中挤出最佳性能的有用信息。


Siv

" Herfried K. Wagner [MVP]" <喜*************** @ gmx.at>在消息中写道

新闻：O8 ************** @ TK2MSFTNGP15.phx.gbl ...

*" Siv" < [e-mail]> scripsit：

我想将这些发现发布给这个社区征求意见，但我记得EULA for .NET中的一些内容，说你不能发布
基准测试。

重新阅读EULA。我记得
测试版禁止使用基准测试，但发布版本可能不是这样。

- MS Herfried K. Wagner
MVP< URL：http：//dotnet.mvps.org/>
VB< URL：http：//dotnet.mvps.org/dotnet/faqs/>

On Sun，2004年9月12日18:45:48 +0100，Siv < [e-mail]>

写道：

作为评估小的一部分我编写的实用程序将大量Excel电子表格中保存的一些数据转换为SQL Server，我决定将该实用程序转换为VB .NET并在IDE中运行这两个版本并且
作为独立编译的exe，看看完成
的时间差异是什么。

该实用程序必须读取3842单页Excel表格，其中包含数据块12行在深度和55列之间，然后将其转移到具有相同列数的SQL Server表中。

我认为VB .NET可能会更慢，但我对此感到惊讶。


确保您设置了Option Explicit On和Option Strict。观察字符串连接
out（改为使用System.Text.StringBuilder）。

注意遗留VB方法，类等，并使用.NET版本

而不是。

我想将这些调查结果发布给这个社区征求意见，但我记得EULA for .NET中的一些内容说你不能发布基准。现在我不和任何人吵架，我不想和MS一起陷入麻烦（特别是我靠微软产品的背后谋生） 。我想要发布的只是一个
表格，显示我的程序的每次运行的开始和结束时间以及计算的VB6和VB .NET的经过时间。
如果来自MS的任何人正在寻找我会很高兴知道你是否会对我发布我的发现感到不满意？

Siv

我肛门，但你应该没事;你试图搞清楚你的​​代码有什么问题。这是为了防止像C＃与Java，

等文章。


Austin

Hi,

As part of an evaluation of a small utility that I wrote that converts some
data held in a large number of Excel spreadsheets into SQL Server, I decided
to convert the utility to VB .NET and run both versions both in the IDE and
as standalone compiled exe and see what the difference in time to complete
was.

The utility has to read 3842 single page Excel Sheets that contain a block
of data 12 rows deep and 55 columns across, this is then transferred into an
SQL Server table with the same number of columns.

I thought VB .NET might be slower, but I was surprised by how much.

I would like to release the findings to this community for comment, but I
remembered something in the EULA for .NET that says you can''t release
benchmarks. Now I am not in the business of falling out with anyone and I
don''t want to get into trouble with MS (particuarly as I make my living on
the back of Microsoft''s products). What I would like to release is just a
table showing the start and end times for each run of my program and the
calculated elapsed times bothe for VB6 and VB .NET.

If anyone from MS is looking in I would be pleased to know if you would be
unhappy about me releasing my findings??

Siv

解决方案

* "Siv" <[e-mail]> scripsit:

I would like to release the findings to this community for comment, but I
remembered something in the EULA for .NET that says you can''t release
benchmarks.

Re-read the EULA. I remember that benchmarks were forbidden for the
beta version, but this is maybe not the case for the release versions.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

Herfried,

I had a look on Google and found the following link to the EULA for the .NET
framework 1.1 Redistributable, which seems to contain the line that I
remember seeing pop up somewhere:

a.. You may not disclose the results of any benchmark test of the .NET
Framework component of the OS Components to any third party without
Microsoft''s prior written approval.

I tried hunting through the .NET IDE help system looking for "Licence"
"EULA" etc but couldn''t find anything.

I suppose the question is, does releasing the timings I have done with my
applications constitute a "benchmark", I don''t think they do, as I am sure
someone will point out that my program should be re-written from scratch
using VB.NET rather than by converting a VB6 app.

My reason for posting it would be to see if anyone had any ideas on how the
application could be improved to get better speed under .NET (as you know
from my previous posts I am converting from VB6 to VB.NET and am looking to
_learn_ rather than take a swipe at Microsoft and I expect to get some
useful information from this group about squeezing best performance from
..NET).

Siv
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:O8**************@TK2MSFTNGP15.phx.gbl...

* "Siv" <[e-mail]> scripsit:

I would like to release the findings to this community for comment, but I
remembered something in the EULA for .NET that says you can''t release
benchmarks.

Re-read the EULA. I remember that benchmarks were forbidden for the
beta version, but this is maybe not the case for the release versions.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

On Sun, 12 Sep 2004 18:45:48 +0100, "Siv" <[e-mail]>
wrote:

Hi,

As part of an evaluation of a small utility that I wrote that converts some
data held in a large number of Excel spreadsheets into SQL Server, I decided
to convert the utility to VB .NET and run both versions both in the IDE and
as standalone compiled exe and see what the difference in time to complete
was.

The utility has to read 3842 single page Excel Sheets that contain a block
of data 12 rows deep and 55 columns across, this is then transferred into an
SQL Server table with the same number of columns.

I thought VB .NET might be slower, but I was surprised by how much.
Make sure you have Option Explicit On and Option Strict set. Watch
out for string concatenation (use System.Text.StringBuilder instead).
Watch out for legacy VB methods, classes, etc., and use .NET versions
instead.
I would like to release the findings to this community for comment, but I
remembered something in the EULA for .NET that says you can''t release
benchmarks. Now I am not in the business of falling out with anyone and I
don''t want to get into trouble with MS (particuarly as I make my living on
the back of Microsoft''s products). What I would like to release is just a
table showing the start and end times for each run of my program and the
calculated elapsed times bothe for VB6 and VB .NET.

If anyone from MS is looking in I would be pleased to know if you would be
unhappy about me releasing my findings??

Siv

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.

Austin

这篇关于VB与VB.NET时序!!的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！