Speed advatage/benefit in enterprise edition

Question

does the speed of our website increase if we host our database on enterprise edition instead of express edition?

Mahesh Chand · Answer

Check this out. SQL Server 2008 is available in many editions to help meet the needs of your organization. Core Editions Specialized Editions Free Editions Enterprise Standard Workgroup Web Developer Express Compact 3.5 Target Scenarios Enterprise workloads that need redundancy and built-in Business Intelligence Shared data scenarios in departments and small to large businesses Remote offices that need local instances of company data For web application hosting Full featured edition for development and testing only Entry level database ideal for learning and ISV redistribution Embedded database for developing desktop and mobile applications CPU 8 CPU 4 CPU 2 CPU 4 CPU OS Maximum 1 CPU OS Maximum Memory 2 TB Ram 64 GB Ram 4 GB OS Maximum OS Maximum 1 GB OS Maximum DB Size 524PB 524PB 524PB 524PB 524PB 10 GB 4 GB Additional Resources Learn More Learn More Learn More Learn More Learn More Learn More Learn More How to Buy Volume Licensing Microsoft Store Volume Licensing Microsoft Store Volume Licensing Microsoft Store Volume Licensing Volume Licensing Microsoft Store Download now! Download now! Licensing Server/CAL Per Proc Server/CAL Per Proc Server/CAL Per Proc Per Proc Developer Tools Free Editions Pricing See our Pricing overview page for more details Free Editions Feature Comparison by Edition For a comparison of the features available in each edition of SQL Server please see here .

Suhani Mody · Answer

Thank you mahesh for the valuable replies :)

Mahesh Chand · Answer

Expression version also allows only one connection while Enterprise can have 100 or more connections. Expression version is good for development and single user only and can be used as MS-Access.

Vilas Gite · Answer

hi Suhani There are data limitation in Express edition elsewhere in Enterprise edition no limitation for data. :)

Vijay Yadav · Answer

ok! Suhani. According to me if you will access the database on same pc by express edition it will also work faster as you said about enterprise edition. Lets other suggest regarding the same. :)

Suhani Mody · Answer

what I have got to know from my search is that express edition can use only one CPU whereas enterprise edition can use multiple.So I thought it can make increase in speed while fetching data from db on dynamic websites.

Vijay Yadav · Answer

Hi Abhi you are right i also didn't hear anything like this before. And Suhani if you have any idea then please suggest us as well.

Abhimanyu K Vatsa · Answer

I don't think so because I never seen such words 'speed' increases when we use enterprise instead of express.