开发者

SQL Server Express seems to run queries much slower than SQL Server

开发者 https://www.devze.com 2023-04-05 05:19 出处:网络
I have both SQL Server and SQL Server Express installed on my desktop PC, and have the AdventureWorks database installed out-of-the-box separately for each.

I have both SQL Server and SQL Server Express installed on my desktop PC, and have the AdventureWorks database installed out-of-the-box separately for each.

When I run the same application against the AW database on SQL Server Express, each query takes more than twice as long to complete. These are simple queries - not particularly demanding. None of the processor cores are under any significant load.

This has surprised me. I would expect that the (commercial) SQL Server would run faster in an enterprise environment with thousands of users: I would not expect to see any difference in开发者_如何学运维 performance for a single-user running a very simple set of queries on a local database.

Has anyone else had a similar experience, or can shed any light on what might be going on here? Thanks.


SQL Server Express is limited to use a single CPU and 1GB RAM, so that could be causing the queries to run slower than the paid editions.

0

精彩评论

暂无评论...
验证码 换一张
取 消