Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have an application that runs on netbooks. It currently uses a SQL Server CE 3.5 database, and we are thinking of upgrading to SQL Server Express.

Just wonder if there are any benchmarks to compare the performance of SQL Server CE and SQL Server Express? Would it be too intensive for an atom netbook?

We are using SQL Server CE 3.5 and we are thinking of moving to SQL Server Express 2012.

UPDATE:
Why are we wanting to upgrade? Because we will now be using merge replication with the SQL Server Express database.

Also we don't want to limit ourselves. We might use stored procedures and triggers on the database because with the replication solution we will be redesigning parts of our system.

share|improve this question
    
I'd be much more concerned about app/code/schema compatibility. Are you upgrading because CE is slow, or some other reason(s)? –  Aaron Bertrand Jun 6 '12 at 0:01
    
I'll update the question because there are a number of reasons for upgrading. –  peter Jun 6 '12 at 0:03
1  
The problem with expecting benchmarks is that nobody else has an app like yours. I'm afraid the best guess you're going to get is to make the conversion and test the app yourself. Even someone who has gone through this process will likely have a different enough application with different enough performance characteristics that you shouldn't be basing business decisions on them. IMHO. –  Aaron Bertrand Jun 6 '12 at 0:08
2  
I'm going to agree with @AaronBertrand. The only way to truly know in your environment and with your implementation is to set it up side-by-side and test. It's just conjecture without doing otherwise. (Unless, of course, somebody has had the same requirement and can give tried-and-true results. But even then, I'd still test test test) –  Thomas Stringer Jun 6 '12 at 1:53
1  
Would it be too intensive for an atom netbook? YES –  Remus Rusanu Jun 6 '12 at 9:01
show 4 more comments

1 Answer

up vote 0 down vote accepted

For your case and reasons to upgrade

merge replication is available in SQL Server CE 3.5

Stored procedures, views, triggers is not available in SQL Server CE 3.5

for a basic comparison between the 2 editions in your case working on a net book

1. SQL Server CE 3.5 can Runs as in-process with application SQL Server Express runs as a service

2. SQL CE supports maximum size of 4GB SQL Express can go up to 10GB

3. SQL CE Doesn't Support FILESTREAM SQL Express Supports FILESTREAM

  1. Procedural T-SQL - Select Case, If, features is not supported in SQL CE Procedural T-SQL - Select Case, If, features is supported in SQL Express

5. Distributed transactions is not supported in SQL CE but supported in SQL express

  1. Native XML, XQuery/XPath is not supported in SQL CE but supported in SQL express

7. Stored procedures, views, triggers is not supported in SQL CE but supported in SQL express

  1. Role-based security is not supported in SQL CE but supported in SQL express

9. concurrent connections supported in SQL CE is limited to 100 but unlimited in sql express

this is a useful blog focused on sql CE

for the comparison between the 2 in your specific environment you can use these tools

SQL LOAD TEST SQL STRESS TEST TOOL

and check this post on SO about sql statment performance http://stackoverflow.com/questions/1555471/what-tools-are-available-to-test-sql-statement-performance

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.