Is the SQL Server 2005 Standard performance twice as fast as SQL Server 2005 Express?
Q: Is the SQL Server 2005 Standard performance twice as fast as SQL Server 2005 Express? I sell software that uses both and aside from limitations to the data size and number of users other consultants always say go with Standard it is twice as fast.
Kevin Kline says: Well, I’d say the other consultants are wrong.
On applications that are agnostic and running relatively few users/connections, you should see little or no difference between Express Edition and Standard Edition.
It is true that Standard Edition can scale much higher. So Standard Edition could potentially be faster (and much more than simply twice as fast) when scaling to dozens, scores, or hundreds of users.
But if the application is for relatively small workloads, the speed should be nearly identical.
Technorati Tags:
SQL Server 2005 Standard, SQL Server 2005 Express, application workloads, scalability