由Virtual Studio express C＃搭建sql server express的程序和付费版一样快吗？ [英] Program built by Virtual Studio express C# with sql server express is as fast as paid version?

问题描述

我想知道是否有任何不同，任何想法？

I am wondering if there is any different at all, any idea?

推荐答案

没有区别 - 代码生成器不会改变。

实际上C＃编译器包含在.NET安装中，从不收取费用！

No difference - the code generator does not change.
In fact the C# compiler is included with the .NET installation that is never charged for!

你真的怀疑你的应用程序是否足够强调你的应用程序低于10GB的限制你会注意到性能问题。当您开始使用连接密集型，多用户并发操作时，多个物理处理器将发挥作用。



当您超出此数据库时，可以将其升级到标准版本没有代码更改。它的后端相同，只是它只使用一个调度程序（因此是单个cpu）。如果您正在使用那么多资源，那么无论如何，您将要查看专用的SQL服务器计算机（或计算机，具体取决于负载）。

Its really doubtful that you will be stressing the database enough with your application below the 10GB limit that you would notice a performance problem. The multiple physical processors come into play when you start using connection intensive, multi-user concurrent operations.

When you outgrow this database, you can upgrade it to a standard version without code changes. Its the same back-end except it only uses one scheduler (hence the single cpu). If you are using that much resources, you are going to be looking into a dedicated SQL server machine (or machines, depending on load) anyway.

您好，



您不太可能看到快递版和付费版之间的性能有任何差异。



无论如何参考的区别是：

1）Sql express只使用1个CPU，付费版本有多CPU支持。

2）Express使用最大1GB的内存，其他版本的操作系统支持的最大值。

3）Express数据库限制为10GB，而其他版本限制为524PB。

4）全部企业版和数据中心版支持各种性能功能。



所以简而言之，确实存在性能差异，但可能这些都不适用于大多数人。



Valery。

Hello,

It's unlikely that you will ever see any difference in performance between the express edition and one of the paid for editions.

Anyway for reference the differences are:
1) Sql express only uses 1 CPU, the paid for versions have multi-cpu support.
2) Express uses a maximum of 1GB of memory, the other editions anything up to the maximum supported by the OS.
3) Express databases are limited to 10GB as opposed to 524PB for the other editions.
4) All kind of performance features are supported by the Enterprise and Datacenter editions.

So in short yes there are performance differences, but probably none of that will ever apply to most people.

Valery.

这篇关于由Virtual Studio express C＃搭建sql server express的程序和付费版一样快吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！