CODEWITHSUNDEEP
sql-serverasp.net-mvc-3entity-framework-4.1sql-server-ce-4
Pankaj Upadhyay
Pankaj Upadhyay

Reputation: 13584

For a small Database site, should i choose SQL CE or SQL Server

I have a website with not more than 100 products which shall grow to 1000-5000 over the period of time if the website grows.

I like SQL CE as its hassle free in deployment and backup. The only thing i am afraid is the performance i will receive from it. My website has 5 tables in the db and i am using entity framework, so a lot of querying goes in and out.

Should i go with the SQL server at the very start or a SQL CE is decent enough in performance for a small to medium ranged website.

Upvotes: 2

Views: 164

Answers (1)

Simon
Simon

Reputation: 1605

I would certainly go for SQL Server. If you have a small budget I would recommend the Express version if you don't do anything fancy : http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx

We use SQL Express for our development environment with more than 20 tables and almost 100000k rows and we never had any performance issue !

If SQL Express is not available, I would still pick SQL Server since no new version of SQL CE is planned and it does not support stored procedures, XML data types, ODBC. Also, SQL CE is optimized for an architecture where all applications share the same memory pool, wich is not the case here with a small website database.

Upvotes: 4

Related Questions