I'm planning to use SQL CE 4.0 in a small but production web site and I'd like to know how much load SQL CE 4.0 can handle:
Limitations of SQL Server Express: 1GB maximum memory used by the database engine. 10GB maximum database size. 1MB maximum buffer cache. CPU the lesser of one (1) socket or four (4) cores (number of SQL user connections NOT limited)
Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications.
Microsoft SQL Server Compact (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops. Prior to the introduction of the desktop platform, it was known as SQL Server for Windows CE and SQL Server Mobile Edition.
Something that might be useful to you is Scott Guthrie's blog post on Wednesday 12 Jan 2011 regarding the latest version of SQL CE and its VS2010 integration: VS 2010 SP1 and SQL CE
To cherry pick a couple of quotes:
Personally I would consider that a 4GB & 256 simultaneous connections in-memory database on a webserver is starting to get a bit big, even though that is the limit for SQL CE, I would look to migrate well before then. It is aimed more at certain scenarios, and if your app doesn't fit that scenario then you should consider SQL Express as Leppie mentioned; i.e. if you can install SQL Express either on your web server or on a machine accessible from your web server then you should do so.
Edit:
just as a follow-up, people should note that you must use VS2012 to work with SQL CE 4.0. SSMS 2008 can be used to work with SQL CE 3.5 (but not 4.0), and SQL CE capability has been removed from SSMS 2012. This means if you are developing with SQL CE 4.0, you must use Visual Studio or a third party tool to do your development work (table creation, etc.).
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With