SQL Server Web 版和 Express 版之间有性能差异吗？
我有一个配备 Windows Server 2008 R2、1 GB RAM 和双处理器四核 2 核的 VPS。
当我询问原因时，我的示例应用程序在共享托管上的运行速度比我当前的网站慢，原因如下：
“与 SQL Server Web 版相比，SQL Server Express 往往速度较慢。这是由于 SQL Server Express 中施加的限制，它基本上仅适用于开发环境。我们观察到 SQL Server Web 版有显着的改进对于虚拟机上面向生产 Web 的应用程序，您可能会考虑这一点。”
这个逻辑只是因为他们想出售网络版数据库还是确实有一些性能优势。我用谷歌搜索，没有发现不同版本之间存在类似的情况。
专家对此有何帮助？
I have a VPS with Windows Server 2008 R2, 1 GB RAM with Dual Processor Quad Core 2 CORES.
My sample application is running slower than my current website on shared hosting, when I asked the reason the says following reason:
"SQL Server Express tends to be slower compared to SQL Server Web edition. This is due to the limitations imposed in SQL Server Express which is basically meant for only development environment. We have observed significant amount of improvements with SQL Server Web edition for production web facing applications on VM's. Hence, this can be something that you might consider."
Is this logic just because they want to sale the Web edition database or there is really some performance benefit. I googled and I didn't find anything like that between different versions.
Any help on this from experts?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
这是绝对错误的。
SQL Express 用于许多、许多、许多生产环境，在这些环境中它可以成为一个很好的工具。
SQL Express 不会因每秒可处理的查询数量而受到限制。然而，正如其他人在此处的回答中所说，它受到 RAM (1GB)、DB 大小 (4GB) 和 CPU (1) 的限制。如果您的数据库在 1GB 到 4GB 之间，您可以很容易地注意到与 SQL Web 的性能差异，其中所有内容都适合一个数据库的内存，而另一个数据库则不适合。
话虽如此，还有许多其他配置/设置/设计选项可以产生更大的影响；详细信息取决于您的数据、模式、访问模式等。
That is absolutely wrong.
SQL Express is used in many, many, many production environments, where it can be a great tool.
SQL Express is not throttled in terms of the number of queries per second it can process. However, as others have said in their answers here, it is limited by RAM (1GB), DB size (4GB) and CPUs (1). If your DB is between 1GB and 4GB, you could easily notice a performance difference vs. SQL Web for scenarios where everything fits into memory on one, but not on the other.
Having said that, there are a bunch of other configuration / setup / design options that can have a much larger impact; the details depend on your data, schema, access patterns, etc.
希望有所帮助：
[链接文本][1]http:// /www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
hope that help:
[link text][1]http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx